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
Sean-OReilly
Helper IV
Helper IV

Need help re Switch

Hi

Im trying to add a Column using Switch Function and when i use the below formula i get blank cells only.

What is wrong with it?

 

Resource No = SWITCH(true(), MK_Job_LedgerEntries[Type] = "Resource", MK_Job_LedgerEntries[No])
 
MK_Job_LedgerEntries[Type] only has 2 results which are "G/L Account" and "Resource" and it is a Text field.
 
1 ACCEPTED SOLUTION
Stachu
Community Champion
Community Champion

Is this in the table 'MK_Job_LedgerEntries'? As this is effectively single condition you could use IF

Resource No = IF(MK_Job_LedgerEntries[Type] = "Resource", MK_Job_LedgerEntries[No])

If it's in a different table then most likely you need to use RELATED on the column references

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community Champion

Is this in the table 'MK_Job_LedgerEntries'? As this is effectively single condition you could use IF

Resource No = IF(MK_Job_LedgerEntries[Type] = "Resource", MK_Job_LedgerEntries[No])

If it's in a different table then most likely you need to use RELATED on the column references

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

thanks @Stachu i got it to work

 

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.

Top Solution Authors