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
James__'s avatar
James__
Helper I
4 years ago

Hello PijushRoy 

 

The MOT has 3 separate products: Single payment, monthly payment and FOC. In the example above, this particular van has a single payment MOT product, and not monthly payment or FOC.

 

Hope that helps.

J

PijushRoy's avatar
PijushRoy
Community Champion
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