Forum Discussion
PowerBI Waterfall Chart for $/Unit
I have 2 talbes which I need to combine to get $/Unit per region/cost category. The talbes are linked through region via an info table--I tried a Many to Many relationship with time period but that didn't help. This is an example of my tables:
I've tried many measures and search for days without success. This only my 2nd PBI.
This is what I expect:
If done in excel this would be the summarized info:
Thanks,
CLAK-2023
CLAK-2023 , Create two common tables, Year and region join back, and try analyze with the help of those
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaThank you, Amit Chandak! I did not consider breaking down the table further. You have saved me for further frustration of making this more complicated than it needed to be!
2 Replies
CLAK-2023 , Create two common tables, Year and region join back, and try analyze with the help of those
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaThank you, Amit Chandak! I did not consider breaking down the table further. You have saved me for further frustration of making this more complicated than it needed to be!