Forum Discussion
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...
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!!
