Forum Discussion
Solved
Calculate Date difference if
Hi, I have a matrix with unique rows. Each row goes through multiple steps (1 through 5). I would like to calculate the Date Difference betwen Today() and the "Started at" date, IF row is at step 5,...
PabloGiraldo ,
Yes you can. Try below DAX in a new calculated measure:Date_Difference = IF(MAX(submittalsacc_tasks[assigned to]) = "Ebuilder External System",DATEDIFF(TODAY(), MAX(Amazon[DATE]), DAY), BLANK())
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
Hi PabloGiraldo ,
Try the below DAX in Calculated Measure:
Date_Difference = DATEDIFF(TODAY(), MAX(Table[DATE]), DAY)
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
Anand24 is it possible to do Date Diff IF submittalsacc_tasks[assigned to] = "Ebuilder External System.
I would like to use this on a card to show how many days the item has been in Ebuilder External System's side. Screenshot below shows my attempt at creating a measure of what i am looking for.
PabloGiraldo ,
Yes you can. Try below DAX in a new calculated measure:Date_Difference = IF(MAX(submittalsacc_tasks[assigned to]) = "Ebuilder External System",DATEDIFF(TODAY(), MAX(Amazon[DATE]), DAY), BLANK())
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn