Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi,
I have a DAX measure for calculating the same day last year (not the same date).
This measure look like this :
Quantity same day LY = calculate(sum('Table'[Quantity]),sameperiodlastyear(DATEADD(DateTable[Date],-1,DAY)))
Now I want to create a new measure for summarizing this measure, but I do not get it done.
Is there someone who can help me in this?
Thanks in advance.
@Jeanneke You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
@Jeanneke , same day 364 days behind. But do with a date calendar
same day Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,Day))
refer Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...
Appreciate your Kudos.
Thanks for your reply.
This isindeed a measure for summarizing.
But I was not clear in my subject. I didn't mean summerize, but cumulatize. Sorry for this.
Hi Amitchandak,
This is the table I am working on :
It is about the column in the red circle.
Here I want the cumulative values based on column "2019".
Column "2019" is calculated :
Covid Quantity Sum Same day LY = calculate(sum('CombinedFacts'[Sum of CalculatedQuantity]),sameperiodlastyear(DATEADD(DateTable[Date],+2,DAY))) |
User | Count |
---|---|
10 | |
8 | |
5 | |
5 | |
4 |