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
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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: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 !!!
LinkedInAnand24 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.
