Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Solved! 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!
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!
Check out the November 2023 Power BI update to learn about new features.