Forum Discussion
Calculate difference between two tables same data, different week of forecast
Hi GabiDN ,
Could you please share some sample data in these three tables(exclude sensitive data) and your expected result with calculation logic and special examples in order to provide you a suitable solution? Also, please provide your visual settings. It is better if you can provide your sample pbix file. Did these data in the matrix come from different tables? Thank you.
In addition, please review the content in the following links. Hope they can help you.
Calculating the total sum of the difference between current and previous weeks?
Calculate difference in values from the current week
Best Regards
Hi Anonymous ,
Thanks for the suggestion.
I try to attache the pbix file here, but the file type is not supported.
The original data comes from the same table, then I creted 2 different tables to show the current week and previous week results. Then I want a 3rd table that shows the difference between them (value, or %).Hi GabiDN ，
You can refer the method in the following thread to upload the file. Besides that, you can share some sample data with Text format and paste it in your post directly. Also please share your visual settings, the formula of measures involved in visuals and expected result with backend logic and special examples. Thank you.
How to upload PBI in Community
Best Regards
Hi Anonymous ,
I attached the file on the link bellow. There are some data in .txt format and the pbix I was working on.
I was trying to create new tables and connect them with the main one using the start schema.
Still not getting the right results. I am trying to play with the filters on the measure now and see where it gets me.
Do you have any other suggestions?
Thank you!
