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
Hikmet_JCI
Frequent Visitor

the last process in a year in a table

Hello

could someone help me please

i try to show the last process in a year in a table

which is filtered on a customer

 

THANKS

1 ACCEPTED SOLUTION
Anonymous
Not applicable

hi @Hikmet_JCI ,

 

Try this

 

_Measure = IF ( Customer[Date] = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez] ) ),Customer[Date] )

 

Thanks!

View solution in original post

6 REPLIES 6
Hikmet_JCI
Frequent Visitor

pic.png

Anonymous
Not applicable

hi @Hikmet_JCI ,

 

Try this

 

_Measure = IF ( Customer[Date] = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez] ) ),Customer[Date] )

 

Thanks!

Anonymous
Not applicable

hi @Hikmet_JCI 

 

Did you try this

 

_Measure = IF ( MAX(Customer[Date]) = CALCULATE ( MAX ( Customer[Date] ), ALLEXCEPT ( Customer, Customer[Bez],Customer[KD] ) ),MAX(Customer[Date]) )

@Hikmet_JCI 

you can try to create a column

Column = 
VAR _max=CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Art]))
RETURN if(_max='Table'[Date],'Table'[Date],blank())

1.PNG





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

Proud to be a Super User!




Hi.
but when I use a filter it doesn't show me correctly

I would have to consider one more column

Hikmet_JCI_0-1623921798851.png

 

@Hikmet_JCI 

then you just need to create a measure

Measure = max('Table'[Date])

please see the attachment below





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

Proud to be a Super User!




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.