Forum Discussion
sabd80
Helper IV
Helper IVPrevious 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...
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
sabd80Helper IV
Helper IVHi 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
Resolver II
Resolver IIHey,
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
Please remove the zero values in your data, that should help in creating the new measure.