Forum Discussion
How to combine two columns with two different criteria
I was able to do it using powerquery, and I know there is solution without using DAX, but just forgot thank you so much for your help!
HI Vanessasfvg,
thanks for the reply! Sure please see below.
With the raw data I have in power query, I want to combine the "Nonchghours" and "chghours" into ONE line, because the data I have is separated. For instance, if the chghours have value in it, the nonchghours has "0" but in reality, if someone has nonchghours and chghours in the same date, it is separated. So I want to combine if the date and email is the same, I want it to show on one line and not two separate lines.
As you can see here, Amee on the same date has 0.4 noncharge hours and 0.2 chargehours but in two different lines and I want to show it on the same line.
This is the final outcome i want, where noncharge hours and chargehours are in one by the email and date.
I was able to do it using powerquery, and I know there is solution without using DAX, but just forgot thank you so much for your help!