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
    7 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
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
7 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
    7 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
      7 years ago

      You are welcome.