Forum Discussion

MG12's avatar
MG12
New Member
4 years ago

Dax for Mutiple Rows

Geography_SKUTVariableID_SKUTVariable_SKUTValue_SKUT
BangloreQues14P NReimbursed with restrictions
BangloreQues22P date06-01-2019
BangloreQues14P NReimbursed with restrictions
BangloreQues22P date06-01-2019
ChennaiQues14P NNot (yet) Reimbursed
ChennaiQues22P date 
ChennaiQues14P NNot (yet) Reimbursed
ChennaiQues22P date 
ChennaiQues14P NNot (yet) Reimbursed
ChennaiQues22P date 
ChennaiQues14P NReimbursed
ChennaiQues22P date04-01-2017
ChennaiQues14P NReimbursed
ChennaiQues22P date04-01-2017
ChennaiQues14P NReimbursed
ChennaiQues22P date04-01-2017

 

Hi Team,
PLease Help  me Create DAX for above Table Req
If P N Contains " Reimbursed with restrictions"" or "Reimbursed " and P Date < Data Parameter Then It should Write me "YES" Else Blank on P Date It should right No 


Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    MG12 what is date parameter? And also in this case it might make sense to pivot the data so that  P N and P Date are on columns instead of rows.

    • MG12's avatar
      MG12
      New Member
      4 years ago

      Actually Data IS Pivoted Down As per Requirement & Date Parameter id Like Calender table (If i select any date That Shoudle Date Parameter)

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    MG12 not sure what you mean data is pivoted, it is not as per the sample you provided. Once you pivot it and create a relationship with your date table everything should be straightforward from there.