Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Hope you can help me with this issue, as it took me a couple of hours today, and I didn't figure it out yet 😞
I want to calculate the number of "Days late" only for the Overdue Status and "Days to Reply" for the Outstanding status.
Responded and N/A status will be Null.
This is what I came to but it's not working:
DaysLate = IF(ISBLANK(Mailbox[ResponseRequiredDate]),"",
IF(Mailbox[ResponseRequiredDate]>TODAY(), IF(Mailbox[Status] = "Overdue", DATEDIFF(Mailbox[ResponseRequiredDate],TODAY(),DAY), ""
I appreciate your help 🙂
//Maryam
Solved! Go to Solution.
Hi @Maryam_Pour
try the measure
Days Late = IF(MIN('Table'[Status])="Overdue",DATEDIFF(MIN('Table'[ResponseReq]),TODAY(),DAY))
Days to Reply = IF(MIN('Table'[Status])="Outstanding",DATEDIFF(TODAY(),MIN('Table'[ResponseReq]),DAY))
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Maryam_Pour
try the measure
Days Late = IF(MIN('Table'[Status])="Overdue",DATEDIFF(MIN('Table'[ResponseReq]),TODAY(),DAY))
Days to Reply = IF(MIN('Table'[Status])="Outstanding",DATEDIFF(TODAY(),MIN('Table'[ResponseReq]),DAY))
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
It works perfectly. Thank you so much 😊
Hey @Maryam_Pour ,
you can get the days late with overdue with the following measure:
Days Late with Overdue =
CALCULATE(
COUNTROWS( myTable ),
myTable[Status] = "Overdue" && myTable[Days Late] = "*"
)
And days to reply with outstanding like this:
Days to Reply Outstanding =
CALCULATE(
COUNTROWS( myTable ),
myTable[Status] = "Outstanding" && myTable[Days to Reply] = "*"
)
Hi Denis,
Appreciate your quick reply.
It seems that I didn't explain my issue correctly. Sorry.
I want to calculate the number of days from the ResponseRequiredDate to Today and call the new column "Days Late" for all Overdue mails. And then, I want to calculate the number of days for Outstanding mails from Today and call the column "Days to Reply."
*** The stars are only to show where the new values should be added.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |