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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ask_kumar
New Member

Max of date for each customer with date slicer

I have a dataset like below
 
 

WvA9F.png

 

I have a date slicer aswell

My requirement is to get the max of date for every name when slicer is selected aswell.

I was able to get the max of date without slicer but when slicer is selected my logic is not working

CALCULATE(MAX(Orders[Date]), ALLEXCEPT(Orders,Orders[Name]))

but this logic not working when date slicer is active.

I need as below

a  10/1/2023
b  8/28/2023
c  6/15/2023

if slicer is selected for 9/30/2023, I need as below

a  9/1/2023
b  8/28/2023
c  6/15/2023

Any help is appretiated

1 REPLY 1
amitchandak
Super User
Super User

@ask_kumar , Try a measure like

 

calculate( max(Orders[Date]), filter(all(Orders), Orders[Name] = max(Orders[Name])))

 

or

 

 

calculate(lastnonblankvalue(Orders[Date], max(Orders[Date])), filter(all(Orders), Orders[Name] = max(Orders[Name])))

 

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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