Forum Discussion

Heybee's avatar
Heybee
Frequent Visitor
8 years ago
Solved

Variation of count - between Fiscal Years

Hello Everyone, I am struggling to calculate a variation of count between fiscal years.   1- I created my fiscal year column using this formula.   _FiscalYearNumber_ = if(MONTH('MyTable'[date_col...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    I still do not know what you want but i have attempted something.  Download my PBI file from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

It will help if you share the link from where i can download your PBI file and also show the expected result there.

Heybee's avatar
Heybee
Frequent Visitor
8 years ago
Ashish_Mathur wrote:

Hi,

 

It will help if you share the link from where i can download your PBI file and also show the expected result there.

 

Hi!

Please, find the file here: PBI file

 

The expected result is the variation graph between Fiscal Years.

 

Hope it is clear.. thank you again!

 

Regards,

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I still do not know what you want but i have attempted something.  Download my PBI file from here.

     

    Hope this helps.

     

    • Heybee's avatar
      Heybee
      Frequent Visitor
      8 years ago

      Thank you very much... this helps me!

      I really appreciate!

       

      Next time I will do my best to be clearer!

       

      Regards

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        You are welcome.