Sales Analysis

Question

Hi All,&nbsp;
&nbsp;
Please review and suggest.&nbsp;
&nbsp;
Thanks,
Bimal
Linkedin -&nbsp;@Bimal Subhasis
eyJrIjoiMzVlNzNkZWQtMDQyNS00ZjdmLWFkZWQtNTRhNjFjZTQ2MWViIiwidCI6Ijg5NGQxMWUzLTM4NWItNDdhYi04MTA5LTgyNGFhNzc2OTU3NiJ9

icad01 · Answer

Nice work.
Thanks for sharing&nbsp;🙂
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

&nbsp;

icad01 · Answer

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

bimalsubhasis · Answer

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.&nbsp;