I'm fairly new to Power Bi and would appreciate assisstance on the following:
I am trying to work out the difference between planned and actual time.
As you can see in image below :
My issue is with the first row. Due to it being a negative, it comes up as 'error'.
I don't need it to show the negative symbol but difference in HH:MM format
The table above is one a I created on Power Bi desktop
Is there a way I can work around this?
Note: I do have excel sheet that shows exactly what I need however when I upload, all formulas mess up. Can I keep my formulas?
Go to Solution.
@Nella ,Refer if this can help
Proud to be a Super User!
View solution in original post
For your case, I would suggst you add a calculate column by dax as below
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.