BimalSubhasis's avatar
BimalSubhasis
Icon for Advocate III rankAdvocate III
4 years ago

Sales Analysis

Hi All, 

 

Please review and suggest. 

 

Thanks,

Bimal

Linkedin - @Bimal Subhasis

Business

3 Replies

  • Icad01's avatar
    Icad01
    Icon for Kudo Collector rankKudo Collector
    4 years ago

    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's avatar
      BimalSubhasis
      Icon for Advocate III rankAdvocate III
      4 years ago

      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.