Dax Help

[sameergupta60]

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

[ryan_mayu]

not clear about your question 

Could you pls explain more on this? or what's your excel formula?

[sameergupta60]

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]

is the BW column the expected output?

[sameergupta60]

yes

[ryan_mayu]

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]

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.

[ryan_mayu]

could you pls provide the sample data which includes different cases and the expected output based on that?

[sameergupta60]

hi

 

[sameergupta60]

suppose my blockwork start date is 10 Oct 22 then it will reflect near to R07 level in the Blockwork table.