Forum Discussion
Calculate Date difference if
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
lbendlin please see link below for sample data. If you expand #2291 on matrix as seen in screenshot below, this item has the example being at Step 5. I would like to create a measure with Date Diff from Today() and, in this example, September 20.https://walshgroup-my.sharepoint.com/:u:/p/pgiraldoclavijo/EVCCoratKVtFpVPC1Sw9WRABcicsjY5237yIp8fNjuVGVQ?e=luphUy
Hi PabloGiraldo ,
Try the below DAX in Calculated Measure:
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