Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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?
Go to Solution.
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
Proud to be a Super User!
View solution in original post
thanks @Stachu i got it to work
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.