Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Isblank function and concatenate in Direct Query

I wanna create a column "Bay & Level" using PickAisle, PickModule, PickBay & PickLevel. Eg: 42B-003-3. If the value is NULL, I want it to be blank.  Mode: Direct Query I am getting the values corr...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    try the following formula:

     

    [PickAisle] & "-" &(if [PickModule] = null then " " else [PickModule]) & "-" & [PickBay] & "-" & [PickLevel]

    Regards,

    MFelix

     

     

workonpower's avatar
workonpower
New Member
6 years ago

Hi, can I see the whole formula for this please?

 

MFelix's avatar
MFelix
Super User
6 years ago

Hi workonpower ,

 

Not sure if this is what you are refering to but:

 

 

[PickAisle] & "-" & (
  if [PickModule] = null then " "
  else [PickModule]) & "-" & [PickBay] & "-" & [PickLevel]

 

This formula is for M language used in the query editor.

 

Regards,

MFelix