Forum Discussion

James__'s avatar
James__
Helper I
4 years ago
Solved

Calculated column HELP!

Hi All,   I'm trying to create a calculated column based on some specific criteria.    So i have a list of LCV registration numbers and i want to identify which ones still have an mot. So the col...
Need Help
  • PijushRoy's avatar
    PijushRoy
    4 years ago

    Hi James__ 

    Can you please try this DAX for calculated column

    CAL_COLUMN =
    SWITCH(
    TRUE(),
    'Table (2)'[Product]="MOT" && 'Table (2)'[Product Type]="Single Payment", 1,
    0)
     
    If solve your requirement, please mark this answer as SOLUTION
    If this comment helps you, please LIKE this comment/Kudos
PabloDeheza's avatar
PabloDeheza
Solution Sage
4 years ago

Hi there!

You can try this:

IF( Product = "MOT", 1, 0 )

Let me know if that helps!