Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have the following use case, where a table contains:
Table_Savings
Product1_LongTerm | Product1_ShortTerm | Product2_LongTerm | Product2_ShortTerm | Product3_LongTerm | Product3_ShortTerm |
500 | 50 | 200 | 20 | 600 | 60 |
100 | 10 | 100 | 10 | 400 | 40 |
600 | 60 | 700 | 70 | 800 | 80 |
And I'd like to create a table that summarizes totals by the Product of each column, like this:
New_Table
Product | LongTerm | ShortTerm |
Product1 | 1200 | 120 |
Product2 | 1000 | 100 |
Product3 | 1800 | 180 |
Would it be possible to create something like this in DAX or any other method?
Thanks a lot!
Solved! Go to Solution.
i imported the data as you shared and did data transform in the PQ editor.
you can check the source and followed the steps I did.
Proud to be a Super User!
pls see the attachment below
Proud to be a Super User!
Thanks @ryan_mayu this is helpful, the problem I have is that my data is not tabulated as per te attributes column you shared. I have em' in separate columns, the tricky part is to actually get to have them in the way you plot them, like all in one single column.
I was thinking maybe transforming the table at a query level would be 'easier'.
i imported the data as you shared and did data transform in the PQ editor.
you can check the source and followed the steps I did.
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |