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 sorry can you help with this query following on from your solution? Can you advise how I would compare Mon this week to Mon last week for all days of the week i.e. Mon vs Mon, Tues vs Tues, Wed vs Wed etc etc. I understand the first 7 records will be blank. I have updated the dataset to have day of the week see link below https://drive.google.com/file/d/1f2yHQQr2DxlXfcUyUMNcEFxl-6TXtloj/view?usp=sharing

I have tried adding on the solution you gave by adding 7 days but it didnt like what I did and threw up some errors. Thanks in advance

Ahmedx's avatar
Ahmedx
Super User
3 years ago

Is this what you are looking for?

  • 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