Forum Discussion
Helper ICount 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:
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
pls try this
Last Month Total New = CALCULATE( COUNTA('Reports'[Team]), 'Reports'[Created On (bins)] IN { EOMONTH(TODAY(),-2)+1}
3 Replies
- Ahmedx
Super User
pls try this
Last Month Total New = CALCULATE( COUNTA('Reports'[Team]), 'Reports'[Created On (bins)] IN { EOMONTH(TODAY(),-2)+1}
fionabeeWorked perfectly, thank you very much 🙂
- Ritaf1983
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