Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
GirishS3
New Member

How to interchange small subcategory Price value with large subcategory price

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
 
 
 

2 REPLIES 2
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.