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

HELP on below query

Dear Team,

 

we need help on the below query attached screenshot.

 

sameergupta60_0-1680239798360.png

 

 

data table in the screenshot we have levels, and the current RCC date if my RCC at 10 then the next column shows RCC date.

FL is not started if blank 

idle days are the calculation of Rcc at datediff(10-floor date, today, day)

 

Output needs in an attached screenshot

 

sameergupta60_1-1680240017383.png

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@sameergupta60 , You can have  measures like

 

Maxx(filter(Table, Table[Project] = max(Table[Project])  && [Level] = "R10") , Table[Date]) , selectedvalue(Date[Date], today()) , day)

 

datediff(Maxx(filter(Table, Table[Project] = max(Table[Project]) && [Level] = "R10") , Table[Date]) , selectedvalue(Date[Date], today()) , Month)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@sameergupta60 , You can have  measures like

 

Maxx(filter(Table, Table[Project] = max(Table[Project])  && [Level] = "R10") , Table[Date]) , selectedvalue(Date[Date], today()) , day)

 

datediff(Maxx(filter(Table, Table[Project] = max(Table[Project]) && [Level] = "R10") , Table[Date]) , selectedvalue(Date[Date], today()) , Month)

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.