Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
4 years ago

Monthly comparison over years

Hello.   I have a month comparison (last year LY and current year CY).  I have a data starting NOV 2021.  How do you make the month comparison start in NOV 2021 instead of JAN 2022.  How do you com...
Need Help
abusen333's avatar
abusen333
Frequent Visitor
4 years ago

OK So the idea is adding new colums to your calendar table and slice by them , same as fiscal year . 

note ;

please dont forget to change the current column to the new colum in your dax measre .

 

  • Oros's avatar
    Oros
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    Hi abusen333 ,

     

    So how do you excatly do that?  Thanks.

    • abusen333's avatar
      abusen333
      Frequent Visitor
      4 years ago

      IT will be easy for to provide example of you problem in power BI format.