Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am using Average by Category quick measure, which does exactly what I need (average of incident count by month).
However I need it to take into account only last year and not the whole dataset.
How do I adjust the DAX code of this quick measure to incorporate this condition?
Here is the DAX code from the quick measure:
I am a newbie, so the more details the better 🙂
Thank you!
Solved! Go to Solution.
@Zalina , with help from date table try like
Last YTD = CALCULATE([Avergae By Category],DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last year= CALCULATE([Avergae By Category],DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last Year = CALCULATE([Avergae By Category],previousyear('Date'[Date],"12/31"))
@Zalina , with help from date table try like
Last YTD = CALCULATE([Avergae By Category],DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Last year= CALCULATE([Avergae By Category],DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last Year = CALCULATE([Avergae By Category],previousyear('Date'[Date],"12/31"))
@amitchandak
Thank you for your help!
The second option worked for me.
I created a new measure and here is the code I used:
It's not exactly the solution for adjusting the quick measure and having one measure for the whole thing, but this serves my purpose.
Much appreciated!
🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
11 | |
10 | |
9 | |
8 |
User | Count |
---|---|
17 | |
12 | |
11 | |
11 | |
11 |