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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Akilles
Regular Visitor

automatically filter latest date for each product/filtrar automaticamente data mais recente

Hello Community!
I have a list of several products where the most recent date is inserted. I would like the dashboard to filter each visual based on the most recent date based on each product.

Olá Comunidade!
eu tenho uma lista de varios produtos onde e inserido com a data mais recente. gostaria que baseado em cada produto o dashboard ja filtre-se cada visual baseado na data mais recente.

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

create a new column

 

filter_most_recent_prod_update =
VAR prod =
SELECTEDVALUE ( 'table'[productname] )
VAR mx_date =
CALCULATE ( MAX ( 'table'[date] ), ALL ( table ), 'table'[productname] )
RETURN
IF ( 'table'[productname] = prod && 'table'[date] = mx_date, 1, 0 )

then filter on this column where = 1





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

1 REPLY 1
vanessafvg
Super User
Super User

create a new column

 

filter_most_recent_prod_update =
VAR prod =
SELECTEDVALUE ( 'table'[productname] )
VAR mx_date =
CALCULATE ( MAX ( 'table'[date] ), ALL ( table ), 'table'[productname] )
RETURN
IF ( 'table'[productname] = prod && 'table'[date] = mx_date, 1, 0 )

then filter on this column where = 1





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.