Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sales Percentage Change based on Fixed Year

Hi Experts   See sample PBIX FIle with data.   I am trying to work out the Percentage Change in Sales month on month based on 2019 Sales.    so 2020 percentage change would be for JAN 20 = (jan...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Try a measure like

    Calculate(Average(SampleData[Average of IEA Demand]), filter(DimDate,DimDate[Date] =2019))

     

    or

     

    Calculate(Average(SampleData[Average of IEA Demand]), DimDate[Date] =2019)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Try a measure like

Calculate(Average(SampleData[Average of IEA Demand]), filter(DimDate,DimDate[Date] =2019))

 

or

 

Calculate(Average(SampleData[Average of IEA Demand]), DimDate[Date] =2019)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    thanks Amit