Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
input table Output table
subcategory Price subcategory Price Output Column
Small 100 Small 100 300
Medium 200 Medium 200 200
Large 300 Large 300 100
I have tried with switch function but not getting output any one please help me out. need to calculate output column using calculate column
@GirishS3 , A new column
Switch(True() ,
[subcategory] = "Small", maxx(filter(Table, [subcategory] = "Large"), [Price]),
[subcategory] = "Large", maxx(filter(Table, [subcategory] = "Small"), [Price]),
[Price]
)
This code is not working getting error like this
The syntax for 'Table' is incorrect. (DAX(Switch(True() ,SELECTEDVALUE('Table'[Sub-Category]) = "Small", maxx(filter(Table, SELECTEDVALUE('Table'[Sub-Category]) = "Large"), 'Table'[Price]),SELECTEDVALUE('Table'[Sub-Cat