Forum Discussion
Column merging based on datatype
Hello guys! I'm stucked in one report and would really appreciate the help since I'm running out of time to turn this in. So, this is for a restaurant that registers its clients in its POS system....
Hi batmanadk
It sucks to see the requirement change but we are developers and we do what we have to do to get the required output and adhere to the timeline.
In this case I would create two new columns s below and use it all the charts and graphs.
Customer_name = IF(ISNUMBER([Customer Name]),[Ticket Entity],[Customer Name]) //Change the data type to text
Ticket_Entity = IF(ISNUMBER([Ticket Entity]),[Ticket Entity],[Customer Name]) //change the datatype to whole number
Thanks Anonymous , yeah sorry about the edit, the thing is I got to a solution in the power query but it doesn't feel simple enough