Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |