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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Dax firstdate with slicer

Hello,

 

I'm having trouble using a date slicer in conjunction with a firstdate expression.

 

Start Date = firstdate ( table [date] ]

)

 

This gives me the results I expect in my matrix. However, I want to use a slicer from my date table to filter my matrix by year. This is not possible as it appears that any year I slice by then becomes the first date.

 

Any suggestion?

 

Thanks

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Try a measure like

measure =
var _min = minx(allselected(Table), table [date])
return
calculate(countrows(Table), filter(Table, Table[Start Date] =_min))

 

But it is better that table come from Date or different Table

measure =
var _min = minx(allselected(date), date [date])
return
calculate(countrows(Table), filter(Table, Table[Start Date] =_min))

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

Thanks for the reply but that did not work.

 

To clarify - my measure works as intended but when I try to slice using my date table all of my start years take on the value of the slicer year. I presume the slicer is filtering my table so that a new start year is shown.

 

I want to be able to get the min date of the table. Once I have the min date, I want to use a slicer to select only the rows that contain that min date. 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors