Forum Discussion

benkenten's avatar
benkenten
Regular Visitor
3 years ago
Solved

Creating Boolean column based on other columns (exists in SQL)

Hi all    Very new to PBI, I have two columns (JournalID and Reversing), with data. I want to create a third column, InReversing, that will evaluate to True, because there is minimum 1 Reversing wi...
  • Kishore_KVN's avatar
    Kishore_KVN
    3 years ago

    Hello benkenten ,

    I can suggest one approach for this problem. Create two columns and make sure to change the datatype of True/False column into Text before creating these two columns.

    DAX for Column 1 will be: 

    Numbering = IF(Data[Reversing]="True",1,0)

    DAX for Column 2 will be:

    Result = 
Var A = CALCULATE(SUM(Data[Numbering]),ALLEXCEPT(Data,Data[JournalID]))
Return
If(A>0,"True","False")

    Output looks like this:

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

     

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
3 years ago

Hello benkenten ,

I can suggest one approach for this problem. Create two columns and make sure to change the datatype of True/False column into Text before creating these two columns.

DAX for Column 1 will be: 

Numbering = IF(Data[Reversing]="True",1,0)

DAX for Column 2 will be:

Result = 
Var A = CALCULATE(SUM(Data[Numbering]),ALLEXCEPT(Data,Data[JournalID]))
Return
If(A>0,"True","False")

Output looks like this:

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!