Help with column creation and additional data sort

[LukeFPowerBI]

Hello

First post so apologies but I cant find anything remotely simlar to this issue i am having, I have just hit a stone wall and cant think and the more i look at the issue the more i can think of an answer.

I created this column from an existing column in my data:

I did a search and replace and 'if online was true' set to online or else i replaced the value to EPOS.  Nice and easy however, I learned that EPOS has back office transactions lumbered in to.

So what I need help with is how I create a column that has EPOS, Online, Backoffice.

The only way to differentiate this is the blanks 

So would need to be not online and if till name is blank then update as backoffice, but i am stumped i have only been using powerbi since october so I am probably out of my

[Mahesh0016]

@LukeFPowerBI ,
#Power Query # Add Column
If [TillName]=Blank() Then "backoffice" Else [TillName]

# Power Query

Select Column Right Click >> Replce Value With Blank >> "backoffice".



#DAX
IF(tillname= Blank(),"backoffice",TillName)

*If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.

[LukeFPowerBI]

Hello @Mahesh0016 thanks for the response, its sadly not as simple as that.

Basically this is what i have via sql for this so far:
Online = ReceivedOnline = 1
SM = ReceivedOnline = 0 and TillID IS NULL
EPOS = ReceivedOnline = 0 and TillID IS NOT NULL

if that makes more sense, if i update all blanks to back office, then the figures will not work it needs to follow that exact mapping, i have troed created a column within the table that references these as the 'filter' if you like but i am really not getting anywhere fast.