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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
IzuruWi
Frequent Visitor

Unable to fetch the selected date in Slicer

Hi All,
I need to fetch the "Start Date" in the slicer, to calculate the "End Date" of the slicer. (which should be the date of 3 months from the "Start Date". I will be using the DateAdd function for that.) Also, "End Date " is essential to calculate using that date. 

Here I have highlighted the start date of the slicer which I need to be extracted.

IzuruWi_0-1675851430834.png


I have used below mentioned DAX to pull, but no luck with that. I'll be grateful If someone can give me a helping hand with this.

 

Date Selected =
CALCULATE ( MIN ( INFO_TABLE[START_DATE] ) )

 

Thanks

 
2 REPLIES 2
jaweher899
Impactful Individual
Impactful Individual

To get the "Start Date" from the slicer in PowerBI, you can use the following DAX expression:

Start Date = MIN(INFO_TABLE[START_DATE])

This expression will give you the minimum date selected in the slicer for the "Start Date" column in the INFO_TABLE.

To calculate the "End Date" using the "Start Date", you can use the DateAdd function as follows:

End Date = DateAdd(Start Date, 3, "Month")

This will give you the date that is 3 months from the selected "Start Date".

Hi @jaweher899 

I have used that method to fetch the "Start Date". But still, the result is similar to the previous one.

Btw, the "End Date" calculation works fine. Thank you very much for that.

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors