Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Icon for Helper IV rankHelper IV
3 years ago
Solved

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] = "Re...
Need Help
  • Stachu's avatar
    Stachu
    3 years ago

    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

     

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
3 years ago

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