Forum Discussion
sabd80
1 year agoHelper IV
Previous week per category
Hi, I would like to get last week volume per category. Below is the total volume for 2 dates per category. the measure is: Volume = sum(table[volume])+0 I want to get the volume of...
- 1 year ago
I found the solution from this site:
https://forum.enterprisedna.co/t/how-can-i-get-the-53-week-last-year-to-appear/18111/14
sabd80
1 year agoHelper IV
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
1 year agoResolver II
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
- sabd801 year agoHelper IV
Please remove the zero values in your data, that should help in creating the new measure.