Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In data table (I can do this in edit queries) I need an IF ELSE statement that looks at these two columns and;
IF NoTE = 1 and LastUpdate2Days = False then TRUE
Else FALSE
I can't figure out how to do this in the data table - create column.
Thanks !
Solved! Go to Solution.
Hi @granade1 ,
You can create a column using DAX as follows:
IF(Table1[Note] = 1 && Table1[LastUpdate2Days] = "False", "TRUE", "FALSE")
NOTE: Replace "Table1" in the above DAX with your table name
If the answer is useful please give Kudos or mark it as a solution if this works! 🙂
Thanks,
Pragati
Hi @granade1 ,
You can create a column using DAX as follows:
IF(Table1[Note] = 1 && Table1[LastUpdate2Days] = "False", "TRUE", "FALSE")
NOTE: Replace "Table1" in the above DAX with your table name
If the answer is useful please give Kudos or mark it as a solution if this works! 🙂
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |