Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] ) )