Forum Discussion
fionabee
Helper I
3 years agoCount How Many Reports Occurred Last Month Without Updating Each Month
I have a stacked bar chart which shows reports made per team on a rolling 12 month basis with a separate section which shows the number made last month. The expression I'm using is: Last Month ...
- 3 years ago
Hi fionabee
The best practice for this kind of calculation is to use date table and time intelligence functions.
Please refer to the linked article:https://radacad.com/power-bi-dax-previous-month-to-date-quarter-to-date-and-year-to-date-calculations
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- 3 years ago
pls try this
Last Month Total New = CALCULATE( COUNTA('Reports'[Team]), 'Reports'[Created On (bins)] IN { EOMONTH(TODAY(),-2)+1}