Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Need Help Using Slicer to Calculate Difference Between Two Dates

Hi Everyone -   I'm looking for help to use a slicer to dynamically calculate the difference between the two dates selected. This is for my "office market statistics project." Specifically, I'm loo...
Need Help
Tips and Tricks
Tutorial Requests
OwenAuger's avatar
OwenAuger
Super User
9 years ago

Hi Paul Anonymous

 

I'm assuming you have a date table called 'Date' with date column 'Date'[Date], otherwise rename.

 

Also you've already defined an [Occ SF] measure by the looks of it.

 

Then a measure something like this should do the trick:

 

Absorption Between First and Last Date =
CALCULATE ( [Occ SF], FIRSTDATE ( 'Date'[Date] ) )
    - CALCULATE ( [Occ SF], LASTDATE ( 'Date'[Date] ) )

 

Owen :)