Forum Discussion

blytonpereira's avatar
blytonpereira
Icon for Helper II rankHelper II
7 years ago
Solved

Linking calendar table issues

Hi Everyone,   I have a dataset for example Period      Brand    Value 2018M01  XX         2 2018M01  XY         3 2018M01  XZ         2 2018M02  XZ        4   I now linked the "Period" colu...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
7 years ago

Hi blytonpereira

 

write your data to the first of each month and don't change the calendar table.

  • blytonpereira's avatar
    blytonpereira
    Icon for Helper II rankHelper II
    7 years ago

    mwegenerThanks for your reply.

     

    I am not quite understanding your method as I am fairly new to POwerBI

    I have shared the .pbix calendar file here

     

    Good DRIVE

     

    PLease try and edit the file itself if possible so I can understand more better

     

    Thanks

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      7 years ago

      Hi blytonpereira

       

      you use a financial calendar.

      The Power BI time intelligence works with the "normal" calendar.

      So the function SAMEPERIODLASTYEAR will not compare the same financial period.

       

      Wikipedia

      "A disadvantage of the 4–4–5 calendar is that it has only 364 days (7 days x 52 weeks), meaning a 53rd week will need to be added every five or six years: this can make year-on-year comparison difficult."

       

      Here my sample pbix file.

      PBIX

      • blytonpereira's avatar
        blytonpereira
        Icon for Helper II rankHelper II
        7 years ago

        mwegener

         

        Thanks a lot. This worked perfectly. I followed your steps, creating a full financial calendar...and then creating a separate unique dates calendar for firest of each month....and then appending the unique dates to my original dataset.

         

        Then I create a relationship Many (my dataset) to One (my full financial calendar). Works great.

         

        I have one more problem:

        For exmaple the date field in your full calendar table in PowerBI, is not a hierarchy, can we create a hierarchy from this ?

         

        Any why is it not happening automatically ?

         

        Thank you

        Blyton