Forum Discussion

GabiDN's avatar
GabiDN
Frequent Visitor
5 years ago

Calculate difference between two tables same data, different week of forecast

Hi,   I am trying to calculate the difference between 2 tables that have the same data, one is filtered to show the current week and the other the previous week. I want to have another table that s...
Need Help
Show and Tell
GabiDN's avatar
GabiDN
Frequent Visitor
5 years ago

Hi Anonymous ,

 

I attached the file on the link bellow. There are some data in .txt format and the pbix I was working on.

Power BI 

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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi GabiDN ，

I tried to download your pbix file, but it failed due to I have Google account. Could you please share the file with me via Private Message? Please exclude sensitive information before share it. Thank you.

By the way, the data in Table 1 is for current week and the data in Table 2 is for previous week? Whether the matrix with difference info also need to include the months?

Best Regards