Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have created these 3 measures for my power bi report and those 3 measures display as columns in the report..
1. column Total Worked:
Hi @Malsha
For your 3rd measure, I think you can use an IF expression with ISBLANK:
Measure = IF(ISBLANK([Total Worked]),"N/A",[Total Worked] - [worked hours for selected period])
Hope this helps.
Hi, This works but it gives duplicated records.
Hi @Malsha
difference =if(isblank( [Total Worked]),"N/A", [Total Worked] - [worked hours for selected period])
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi, This is working but it gives duplicated records. what's the reason for that.
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |