Forum Discussion

LukeFPowerBI's avatar
LukeFPowerBI
New Member
3 years ago

Help with column creation and additional data sort

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...
Need Help
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

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's avatar
    LukeFPowerBI
    New Member
    3 years ago

    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.