Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Table 1 using this I need to create a Table 2 as shown in the image below. I would appreciate any help with the logic on this to be done either using DAX or maybe in Tableau. Thank you.
Note: If a transaction id has a class 'SP' then for that transaction id replace the class 'WSP' with 'SP' and then get the sum for that transaction id.
Solved! Go to Solution.
This Column for New Revenue
New Revenue = CALCULATE ( SUM ( TableName[Revenue] ), ALLEXCEPT ( TableName, TableName[Transaction ID] ) )
HI @ketan10
Try this Calculated Column
New Class = IF ( CALCULATE ( COUNTROWS ( TableName ), FILTER ( ALLEXCEPT ( TableName, TableName[Transaction ID] ), TableName[Class] = "SP" ) ) >= 1, "SP", TableName[Class] )
This Column for New Revenue
New Revenue = CALCULATE ( SUM ( TableName[Revenue] ), ALLEXCEPT ( TableName, TableName[Transaction ID] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |