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 ,

 

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 %).

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • 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