Forum Discussion

Sorakell's avatar
Sorakell
Frequent Visitor
7 years ago
Solved

Problem creating a column filtering two other columns on same table

Hello community!   I have a custom column with dates and would like to make a copy of this same column but tweaking it a little. I want this new column to give me blank spaces when the conditions i...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi  Sorakell,

     

    Looking at your data I think it's easier to do it by if has a No or end date is blank return blank.

     

    See below the code for DAX and also for M language  (query editor).

     

     

    Query Editor (M Language)

if ([Finalizado] = "No" or [first end date] = null) then null else [end date]

    ================
DAX

Expected end date DAX =
IF (
    Table1[Finalizado] = "NO"
        || Table1[first end date] = BLANK ();
    BLANK ();
    Table1[end date]
)

    Regards,

    MFelix

     

MFelix's avatar
MFelix
Super User
7 years ago

Hi  Sorakell,

 

Looking at your data I think it's easier to do it by if has a No or end date is blank return blank.

 

See below the code for DAX and also for M language  (query editor).

 

 

Query Editor (M Language)

if ([Finalizado] = "No" or [first end date] = null) then null else [end date]

================
DAX

Expected end date DAX =
IF (
    Table1[Finalizado] = "NO"
        || Table1[first end date] = BLANK ();
    BLANK ();
    Table1[end date]
)

Regards,

MFelix

 

  • Sorakell's avatar
    Sorakell
    Frequent Visitor
    7 years ago

    Wow Felix! that formula you gave me worked perfectly! its amazing!. 

     

    Now I only have one more step to achieve the final result. I need to concatenate "expected end date" with "nº vehiculo" applying the same filters as before.

     

    I want the concatenate result: "nº vehicleexpected end date" only when finished is "yes" and "end date" is not blank.

     

    I'm tryingto do it with calculate but I'm not able to do it.

     

    Could you give me a hand? 

     

    Thanks a lot! you saved me a lot of time...