Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
i have question ,
IF DateTime on Column is greater than 2 February 2022 at 5:00:00 pm will result late , else ontime
Thanks
SE
Solved! Go to Solution.
@Anonymous Write the following DAX:
Column = IF(Table[DateTime Column]>"02-02-2022 05:00:00" , "Late","OnTime")
Edit: Column = IF(Table[DateTime Column]>dt"2022-02-02 05:00:00" , "Late","OnTime")
@Anonymous Write the following DAX:
Column = IF(Table[DateTime Column]>"02-02-2022 05:00:00" , "Late","OnTime")
Edit: Column = IF(Table[DateTime Column]>dt"2022-02-02 05:00:00" , "Late","OnTime")
In DAX or Power Query
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |