Forum Discussion

Jpss's avatar
Jpss
Resolver II
1 year ago

hey sabd80 
here is the solution i created for you. 

I created it with following measure. 

lastWeekVolume = CALCULATE(SUM('Table'[Value]), DATEADD('Table'[Date],-7,DAY))

I transformed the dataset in following format for this measure 

 

I hope this helps. 

 

  • sabd80's avatar
    sabd80
    Helper IV
    1 year ago

    Hi Jpss ,

    It did not work, because I don't have the records for the zero values in the data.

    Yours work because you have the records for zero values.

    Also the pbix file you have sent me is different from the screenshot you have provided

    • Jpss's avatar
      Jpss
      Resolver II
      1 year ago

      Hey, 
      I created the solution based on the screenshot you shared.  It will be helpful if you can share a working PBIX file  that demonstrates your use case scenario and issue you have described above

       

      • sabd80's avatar
        sabd80
        Helper IV
        1 year ago

        Please remove the zero values in your data, that should help in creating the new measure.