Query Formula Help

[erhan_79]

hi Doctors of Power BI 🙂 

first of all i would like thanks for your kind supports to us 

I need a support as below thanks in advance 

i have table on power bi , i have delivery date and and request date , i would like to create a new column which is calling new delivery date as on right of table , but i need to create this column on query editor 

rule will be like that 

if request  date is full then use request date , if request date is empty then use delivery date 

also i would like to learn one more thing at the same taie pls : infact on power bi desktop i can use below formula and solve the problem but below formula i can not use in the query , i think query formula style and desktop formula style is different 

IF(ISBLANK(table[request date ]),table[Delivery date],table[Request date])

[Greg_Deckler]

#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [Request Date] = "" then [Delivery Date] else [Request Date])

[Pragati11]

HI @erhan_79 ,

The formula what you have got is a DAX expression.

Query editor uses another language called M-query.

You can write following formula in Query editor:

if([Request date ] = null) then [Delivery date] else [Request date])

Go to Query editor --> Under ADD COLUMN on the to ribbon, select CUSTOM COLUMN

A window appears and paste the above formula there. Don't forget to name your new column.

Thanks,

Pragati

[erhan_79]

dear @Pragati11 

thanks for your reply but i tried your formula as below but it gives error 

do i something wrong could you pls check 

[Pragati11 · Accepted solution]

Hi @erhan_79 ,

Just remove the last bracket sign where it is showing red.

Thanks,

Pragati

[erhan_79]

thank you vry much @Pragati11  now it is working