Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Categorize materials by sales

Hi all, I'm still learnig the ropes with Power BI and trying to solve this scenario and I'm stuck. The model below contains two fiscal years of data. What I need to do is identify the total sales fo...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

I may be able to solve it but my solution will work only for 2 static Fiscal years.  in the next FY, when the current FY becomes the previous FY, then my solution will not work. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ashish_Mathur 

 

I can work with hard coded fiscal years. 

 

How would you do it?

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

    Hi,

    i can try but not sure of how successful i will be.  Share the download link of the PBI file.