Forum Discussion

Abz_17's avatar
Abz_17
Helper I
3 years ago
Solved

Calculate Percentage Change

Hi, I am having trouble calculating Percentage Change on the previous day   I have a dataset which holds the following data going as far as 14/02/2023   https://drive.google.com/file/d/1LRV...
Need Help
Show and Tell
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    try like this:

     

     

    Stock Change = CALCULATE(sum(qryExportStock_Totals[Total]),
                         ALL(qryExportStock_Totals),
                         PREVIOUSDAY(qryExportStock_Totals[StockDate]))

     

     

Ahmedx's avatar
Ahmedx
Super User
3 years ago

try like this:

 

 

Stock Change = CALCULATE(sum(qryExportStock_Totals[Total]),
                         ALL(qryExportStock_Totals),
                         PREVIOUSDAY(qryExportStock_Totals[StockDate]))

 

 

  • Abz_17's avatar
    Abz_17
    Helper I
    3 years ago

    Thank you