Change day to hours in specific rows

[RobinH]

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

[serpiva64 · Accepted 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 !

[RobinH]

Thank you very much, workt great 👍