Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
FPP
Helper I
Helper I

MAX Date of what user selected

‎04-18-2024 11:16 AM

Hi, I have a date table with Date, Year, Month, Year-Month, Year-Month-Name.

My report has a visual where the user can select a Year and another where they can select Multiple Months.

If the user selects 2024 and then Jan, Feb, March and April I need the following:

Year-Month-NameMyMaxDateMyMaxMonthName
Jan 2024Apr 30, 2024Apr, 2024
Feb 2024Apr 30, 2024Apr, 2024
March 2024Apr 30, 2024Apr, 2024
April 2024Apr 30, 2024Apr, 2024

 

Note: My Date table has a record for every day from

1/1/2017 all the way to 12/31/2024

Message 1 of 2
187 Views
0
1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

‎04-18-2024 11:27 AM

@FPP MAXX(ALLSELECTED('Dates'), [Date])



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Message 2 of 2
174 Views
1 REPLY 1
Greg_Deckler
Super User
Super User

‎04-18-2024 11:27 AM

@FPP MAXX(ALLSELECTED('Dates'), [Date])



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Message 2 of 2
175 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All