Forum Discussion
Clustered Column Chart with same period last year
Super UserHi,
How does one download that file? Also, why are entries in the Claim number showing up as dates?
Ashish_Mathur If you don't know how to use git then you can download a zip by clicking 'code' (in green) here https://github.com/TheKLegacy/uploads.
The values in claim number aren't important, we are getting the count of them. Let me know if you have any other questions. Thanks for the help.
- Ashish_Mathur
Yeah changed to to the visualisation I need and it's exactly what I want. Do you know what I was doing wrong?
- amitchandak
Anonymous , Yet to check your Data. But for the same period last year. I prefer a trailing measure with Date calendar
example -Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Or, see if this can also work
CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9To 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-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.Thanks for the reply. I think the core of my problem is how the filter is effecting my measure of counts for same period last year. Do you know any options in power bi that might explain this behavior? (See my last two posts including screenshot for more details)
