Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a measure of Dax and I want to create another measure based on it. Below given table is measure condition and outcome that should come.
Measure | Status | Outcome |
23/12/2021 | Y | Compliant |
02/11/2020 | Y | Not Compliant |
13/05/2021 | N | Not Required |
07/02/2021 | N | Not Required |
31/08/2020 | Y | Not Compliant |
I want if status is N the outcome should be Not required but If status is Y then it should go measure of date and check if date is less than today so Non compliant and if date measure is greater than today it should be compliant. Can anyone help? It would be really helpful.
Thanks
Solved! Go to Solution.
or based on what I comprehended, here is the solution
Outcome =
var CheckDate = if(Measure<today(),"Not Compliant","Compliant")
return
if(Status="N","Not Required",Outcome)
Hi,
tbh I think we need you to elaborate..
the table above is the outcome or the table you have?
Hello @amaniramahi ,
First two columns are to be used while third column is what I am expecting the answer should be.
so check my other comment