Forum Discussion

radovankubis's avatar
radovankubis
New Member
8 years ago
Solved

Calculated measure returning Text

HI Guys, I am quite new in the community - please be patient with me. I have below table:     Mfr Pt No - MD04 Product Description STRAT SYD1-01 MAC1-01 SYD1-SN SYD1-WL 24888 WHEEL C...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi radovankubis,

     

    To achieve your requiremnet, please refer to steps below:

    1. Click Query Editor->Add Column->Custom Column and add 4 custom columns using formula:

     

        #"Added Custom" = Table.AddColumn(#"Changed Type", "Strat SYD1-01", each if [#"SYD1-01"] <> null then [STRAT] else null),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Strat MAC1-01", each if [#"MAC1-01"] <> null then [STRAT] else null),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Strat SYD1-SN", each if [#"SYD1-SN"] <> null then [STRAT] else null),
    #"Added Custom3" = Table.AddColumn(#"Added Custom2", "Strat SYD1-WL", each if [#"SYD1-WL"] <> null then [STRAT] else null)

    2. After applied, create a table visual like below:

     


     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi radovankubis,

 

To achieve your requiremnet, please refer to steps below:

1. Click Query Editor->Add Column->Custom Column and add 4 custom columns using formula:

 

    #"Added Custom" = Table.AddColumn(#"Changed Type", "Strat SYD1-01", each if [#"SYD1-01"] <> null then [STRAT] else null),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Strat MAC1-01", each if [#"MAC1-01"] <> null then [STRAT] else null),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Strat SYD1-SN", each if [#"SYD1-SN"] <> null then [STRAT] else null),
    #"Added Custom3" = Table.AddColumn(#"Added Custom2", "Strat SYD1-WL", each if [#"SYD1-WL"] <> null then [STRAT] else null)

2. After applied, create a table visual like below:

 


 

Regards,

Jimmy Tao