Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sameergupta60
Helper IV
Helper IV

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

 

sameergupta60_1-1673507341036.png

 

 

9 REPLIES 9
ryan_mayu
Super User
Super User

not clear about your question 

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





Did I answer your question? Mark my post as a solution!

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?





Did I answer your question? Mark my post as a solution!

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"&&not(ISBLANK('Table'[Block Work start date]))),'Table'[Block Work start date])
return if(_f="R"&&_a<>""&&'Table'[Block Work start date]=_bw,1)

1.PNG





Did I answer your question? Mark my post as a solution!

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




 

hi

q.jpg

sameergupta60_0-1673517859177.png

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.