Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to find out how to get the desired results. In my TEST_TABLE, the USED column is what I want to place my results. If there is a value in the ENQ or VAR column I want it flagged as TRUE. I am sure this is a nested IF statement, but I am very new to Power BI. Any help is greatly appreciated.
Solved! Go to Solution.
Hi,
Try this calculated column formula
=OR(ISNUMBER(Data[ENQ]),ISNUMBER(Data[VAR]))
Hi,
Try this calculated column formula
=OR(ISNUMBER(Data[ENQ]),ISNUMBER(Data[VAR]))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |