Forum Discussion
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 should give me a result "not correct"
for others they should give me info "correct.
Thanks!
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
6 Replies
smpa01Community Champion
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
Hey
im trying to add "New Measure" and created in power BI new dashboard which will give me this status about the errors
Action status Forecasted date of execution Completed 13.10.2021 correct Completed 15.10.2021 correct Completed not correct Completed not correct Completed 14.10.2021 correct Completed 14.10.2021 correct Completed not correct Completed not correct Completed 01.11.2021 correct Completed 14.10.2021 correct - smpa01
CalculatedColumn= if(tbl[Action Status]="Completed"&&tbl[Forecasted Date]=BLANK(),"not correct","correct")
