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 You have been a great help so far and I have found your tips very useful. I was wondering if you could help me with a final query using the same dataset? For each day I have to work out days worth of stock using another table, however the stock day data changes every month. Can you advise on how I could work out the days stock using the date ranges attached. I did try a few if statements but I couldnt get them to work. I need to divide the total from the orignal data (In pic below - January highlighted Yellow on left by the cell highlighted yellow on the right to get the cells highlighted in Green as the final output) for everyday

 

extra data is here

https://docs.google.com/spreadsheets/d/1MVoqs-7DtpVoDTzXrh_o_6FXvK80VKDP/edit?usp=share_link&ouid=105822670682691921795&rtpof=true&sd=true

 

Again any help will be appreciated.