Forum Discussion

Smolik1980's avatar
Smolik1980
New Member
4 years ago
Solved

Pls Help Dream Team

I have one table "Action Status" and second "Forecasted Date"  and now I would like to bild the function "IF". If "Action Status" table has option "Completed and Forecasted Date" is "blank" it shou...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Smolik1980 

     

    This is a calculated column:

    CalculatedColumn= if(tbl[Action Status]="Completed"&&tbl[Forecasted Date]=BLANK(),"not correct","correct")

     If you want to create a measure, you need to modify this code.

    Like this:

    Measure =
IF (
    MAX ( tbl[Action Status] ) = "Completed"
        && MAX ( tbl[Forecasted Date] ) = BLANK (),
    "not correct",
    "correct"
)

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

     

    Best Regards,
    Community Support Team _ Janey

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Smolik1980  

CalculatedColumn= if(tbl[Action Status]="Completed"&&tbl[Forecasted Date]=BLANK(),"not correct","correct")

Smolik1980's avatar
Smolik1980
New Member
4 years ago

thanks, but something is still wrong, the problem is with Status Data, I have an alert as below:

 

A single value for column 'Action status' in table 'Rejestr postępowań zakupowych' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Smolik1980 

     

    This is a calculated column:

    CalculatedColumn= if(tbl[Action Status]="Completed"&&tbl[Forecasted Date]=BLANK(),"not correct","correct")

     If you want to create a measure, you need to modify this code.

    Like this:

    Measure =
IF (
    MAX ( tbl[Action Status] ) = "Completed"
        && MAX ( tbl[Forecasted Date] ) = BLANK (),
    "not correct",
    "correct"
)

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

     

    Best Regards,
    Community Support Team _ Janey