Sales Analysis 12-09-2021 04:51 AM

[BimalSubhasis]

Hi All, 

Please review and suggest. 

Thanks,

Bimal

Linkedin - @Bimal Subhasis

eyJrIjoiMzVlNzNkZWQtMDQyNS00ZjdmLWFkZWQtNTRhNjFjZTQ2MWViIiwidCI6Ijg5NGQxMWUzLTM4NWItNDdhYi04MTA5LTgyNGFhNzc2OTU3NiJ9

[Icad01]

Take a look at:
https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-...
Or even better:
https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query

[Icad01]

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

[BimalSubhasis]

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.