Forum Discussion

revansh's avatar
revansh
Helper IV
8 years ago
Solved

Case statement comparing two columns - DAX FUNCTION

Hi All,           Could you provide some inputs in writing a dax function for below scenario.   Case when (table1[column1] = 1 and table2[column1] = 1) then 1 when (table1[column1] = 1 and tabl...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi revansh,

     

    If you share some detail contents, it will be help to clarify your scenario.

    If you already cross join or use related function to merge these columns to one table, you can try to use below formula to create a calculate column to return the result.

     

     

    Result=if([T1 Column1]-[T2 Column1]=0,1,0)

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi revansh,

 

If you share some detail contents, it will be help to clarify your scenario.

If you already cross join or use related function to merge these columns to one table, you can try to use below formula to create a calculate column to return the result.

 

 

Result=if([T1 Column1]-[T2 Column1]=0,1,0)

 

 

Regards,

Xiaoxin Sheng