11-20-2021 00:34 AM
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.
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),
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.