Forum Discussion
Calculate data in 2 table with no relationship
Hi all,
Please help to advice, how to get blue area = red area/ green line
Thank you!!
Cherry04
Assuming you want to achlieve this in Power BI with DAX.
I would suggest to unpivot the yellow area and green area into two diffierent tables in Power Query and load them into power bi. Then create a matrix visual in power bi to achieve the desired result.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
1 Reply
- tharunkumarRTK
Super User
Cherry04
Assuming you want to achlieve this in Power BI with DAX.
I would suggest to unpivot the yellow area and green area into two diffierent tables in Power Query and load them into power bi. Then create a matrix visual in power bi to achieve the desired result.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun