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.
Hello all,
I am building a report to give organisational data to senior stakeholders. What I need in the report is a date count between a due date and the reporting date which is always the last calendar day of the previous month.
This is the DAX that I am currently using which is based on a criteria within my final PDR rating column. This works for the reporting date of 31st Jan 21.
However, the obvious issue is that I would have to go into the formula and change the reporting date every month.
Does anyone know of any way of getting this to automatiocally count the calendar days from the PDR due date and the last calendar day of the previous month?
Any help would be appreciated.
Regards,
Emily.
Solved! Go to Solution.
@EmilyM2019 , Try like
Count of days since due date = IF('WFP data'[Final PDR rating]="Outstanding",DATEDIFF('WFP data'[PDR due date],eomonth(today(),-1),DAY),BLANK())
You can use EOMONTH(TODAY(), -1) to get the last date of the previous month dynamically.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@EmilyM2019 , Try like
Count of days since due date = IF('WFP data'[Final PDR rating]="Outstanding",DATEDIFF('WFP data'[PDR due date],eomonth(today(),-1),DAY),BLANK())
Great, thank you.
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 | |
110 | |
91 | |
84 | |
66 |