The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Nice work.
Thanks for sharing 🙂
In your online sample, there was a little display problem.
The line visual had a horizontal scrollbar
and didn't show all the years at once:
But I see you fixed it in your pbix file:
Sometimes I had to create a column to fix this annoyance.
in DAX:
End of Month = EOMONTH([Date],0)
Or in Power Query:
#"Inserted Start of Month" = Table.AddColumn(#"Inserted Month", "Start of Month", each Date.StartOfMonth([Date]), type date),
Arie
Thanks for the suggestion. I was wondering if we have any DAX to create a separate calendar table to all our reports. Apologies i am still in learning phase hence looking for a best solution. I want to setup a individual calendar file which will be looped to all my data tables. There should be an auto update method as well with the latest date.