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.
Hello community
did not find a fitting solution.
I have a table with days and hours mixed. i need to show all values in hours.
Samplefile:
https://1drv.ms/x/s!AhAHMdCrj8gdgrZSeLVCqQZvMOQ7Ww?e=pPU8bC
The solution would be something like "if unit is "Days" then multiply column "today/EoY/jan/feb/..." by 8.
Will convert the negative values into positive.
I could do it by hand in the sourcefile (Excel), but it defenitely would be more convinient if it is possible in PBI.
Thank you all
regards Robin
Solved! Go to Solution.
Hi,
if you want to achieve something like this:
You have to:
- select the 2 first column and unpivot other colums
- add a custom column
- insert the absolute value
and that's done.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi,
if you want to achieve something like this:
You have to:
- select the 2 first column and unpivot other colums
- add a custom column
- insert the absolute value
and that's done.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Thank you very much, workt great 👍
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |