Margin Variance Bridge

[Grzegorz89]

Hi All,

I am building the Margin Variance Bridge. I have a data set for 2023 and 2024 by month. (Data are conslidated on Part number and country level: S289KR Germany, S289KR Poland). The static version which I calcualte for 23 vs 24 is working fine. 

I am wonder if possible is to create it based on two periods filters, (Base period and Current period). Those two periods should be dynamic and based on user selection consolidate the data. example, March vs April, two months vs one month etc.

Could you please advise if this is possible or move me to the right direction. Thanks a lot.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...