Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
19 | |
11 | |
10 | |
8 | |
8 |
User | Count |
---|---|
20 | |
13 | |
8 | |
7 | |
6 |