Forum Discussion

sameergupta60's avatar
sameergupta60
Icon for Helper IV rankHelper IV
3 years ago

Dax Help

Hi Team   If my RCC level is on R07 then my BW should start if it started showing 1, or not showing zero in another column we need dax for the above querry attaching excel with data Case 1   ...
Need Help
sameergupta60's avatar
sameergupta60
Icon for Helper IV rankHelper IV
3 years ago

hi,

 

My query is if my RCC level is on r07 then  my block work has to start date .

 

but if my BW start date  is not started at any level then it is 0 or 1.

 

for that, we need dax or measure.

 

Regards,

Sameer Gupta

 

 

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

is the BW column the expected output?

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      3 years ago

      pls check if this is what you want

       

      Column = 
VAR _f=left('Table'[Levels],1)
VAR _a=maxx(FILTER('Table','Table'[Levels]="R07"),'Table'[Levels])
VAR _bw=minx(FILTER('Table',_f="R"&&not(ISBLANK('Table'[Block Work start date]))),'Table'[Block Work start date])
return if(_f="R"&&_a<>""&&'Table'[Block Work start date]=_bw,1)

      • sameergupta60's avatar
        sameergupta60
        Icon for Helper IV rankHelper IV
        3 years ago

        thanks for your support,

         

        but my query is if my RCC is on R07 then block work should start date ideally.

         

        if block work has not started at with respective RCC floor r07 then it should be 0 or 1.