Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

problem with matrix total

hi everyone. I have 2 sales fields, one from 2019 and the other from 2018, the matrix is ​​seen per week. I made a measure so that if the sales field of 2019 has no value, the sale of 2018...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, I tried to use the solution you gave me but the results come out in 0. I should point out that I have a general sale and I divided it into 2 to make one for the year 2019 and another for 2018 I don't know if this influences.
 
The origin of the problem is that I make a matrix with the accumulated daily and I compare it with the same period last year but at the time of accumulating what of 2019 if it has 3 days in 2018 I accumulate the whole week
 

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

hi,

 

Thanks for your reply.

Please share the pbix file with me if convenient. You can upload the pbix file to your OneDrive, paste the share link here.

And remember removing any sensitive data within the report.

 

Best Regards,

Giotto Zhi