Forum Discussion

DaniBi92's avatar
DaniBi92
New Member
5 years ago

DATEDIFF with values in different Rows and Fields

Hi, is it possible to use a DATEDIFF formulas with values in different Rows and Fields(or another DAX formulas)? For example, i 've the following Data: ITEM STATUS DATE1         DATE2 XXX...
CALCULATE
DATEDIFF
DAX Commands
Help me
Help Requested
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, DaniBi92 

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample b pbix file, and all steps are numbered in front of each measure.

 

 

https://www.dropbox.com/s/4lwg972lhq9ki9q/danibi.pbix?dl=0 

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM