Getting date for calculation

1
votes

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.

1
powerbipowerbi-desktop

1 Answers

0
votes

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.