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]))

     

     

Abz_17's avatar
Abz_17
Helper I
3 years ago

Ahmedx Can this be done in the data table rather than a visual? I dont want to have W1 etc. Wanted to keep the same format as this

 

but instead of the 3rd column showing previous day, i want it to show 7 days prior like this excel sheet has with colour coding, going all the way down to the end of the data

 

 

  • Abz_17's avatar
    Abz_17
    Helper I
    3 years ago

    thank you Ahmedx really appreciate it