Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
not clear about your question
Could you pls explain more on this? or what's your excel formula?
Proud to be a Super User!
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
is the BW column the expected output?
Proud to be a Super User!
yes
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"&¬(ISBLANK('Table'[Block Work start date]))),'Table'[Block Work start date])
return if(_f="R"&&_a<>""&&'Table'[Block Work start date]=_bw,1)
Proud to be a Super User!
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.
could you pls provide the sample data which includes different cases and the expected output based on that?
Proud to be a Super User!
hi
suppose my blockwork start date is 10 Oct 22 then it will reflect near to R07 level in the Blockwork table.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |