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 you want calculated column/measure? want this to be done through PQ/DAX? what is the relationship?

Spare more details and provide sample data

 

Smolik1980's avatar
Smolik1980
New Member
4 years ago
Action statusForecasted date of execution 
Completed13.10.2021correct
Completed15.10.2021correct
Completed not correct
Completed not correct
Completed14.10.2021correct
Completed14.10.2021correct
Completed not correct
Completed not correct
Completed01.11.2021correct
Completed14.10.2021correct
  • 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