AnswerBun.com

Getting date for calculation

Stack Overflow Asked by Faizan Gauhar on December 12, 2020

I am a new user of Power BI and I was wondering if it is possible to calculate the date difference that is present in two different tables but they both are connected to the third table in which I want to create a measure or a column using dax to calculate date difference:

enter image description here

The columns marked in red are dates and I want their difference to be calculated in the assumption table. I used the month number to build the relationship between these tables.

One Answer

You can use a Measure as below-

date_diff = 
DATEDIFF(
    RELATED(d_nl[notification]), 
    RELATED(d_fc[file_closure_date]), 
    DAY
) 

To know about other Intervals rather than DAY, you can visit Here.

Answered by mkRabbani on December 12, 2020

Add your own answers!

Related Questions

Creating a Message for Gmail API in C#

3  Asked on December 1, 2021 by muttley91

   

how do I seed data to firebase firestore

4  Asked on December 1, 2021 by sambulo-senda

     

OpenCV Frame Grabber not work on MacOS Catalina

1  Asked on December 1, 2021 by wojciech_cichocki

         

relative rotation in 3D

2  Asked on December 1, 2021

   

How to Mock the ActivityContext Class

0  Asked on December 1, 2021 by mathiyazhagan

       

Nested array into array, adding brackets around nested array

1  Asked on December 1, 2021 by stackaccount1

   

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP