cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I

How to get value from date slicer

Hi Everyone,

I am trying to get the date out of this slicer to use it in a formula.  How can I get 3/31/2018 from a slicer in order to pass it to the calculated column?

Any help would be greatly appreciated

Any help would be greatly appreciated

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Rahulsingh,

Use this formula:

`Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))`

Regards.

9 REPLIES 9
Anonymous
Not applicable

Hi @Rahulsingh,

Use this formula:

`Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))`

Regards.

Helper I

Hi There,
I have written the same formula to get the min & max value from the date slicer but for some reason it's not working for me.

Here is the formula to get slicer start & end date

startDate = CALCULATE(MIN('CASE_DEFLECTION_ANALYSIS'[SYS_CREATED_ON].[Date]), ALLSELECTED('CASE_DEFLECTION_ANALYSIS'))

endDate = CALCULATE(MAX(CASE_DEFLECTION_ANALYSIS[SYS_CREATED_ON].[Date]), ALLSELECTED(CASE_DEFLECTION_ANALYSIS))

Is there something I need to do in the desktop settings?

Frequent Visitor

Try Removing .[Date] and it should work.
Updated DAX

startDate = CALCULATE(MIN('CASE_DEFLECTION_ANALYSIS'[SYS_CREATED_ON]), ALLSELECTED('CASE_DEFLECTION_ANALYSIS'))

endDate = CALCULATE(MAX(CASE_DEFLECTION_ANALYSIS[SYS_CREATED_ON]), ALLSELECTED(CASE_DEFLECTION_ANALYSIS))

Please give a Thumbs-up if it worked

Anonymous
Not applicable

@Anonymous wrote:

Hi @Rahulsingh,

Use this formula:

`Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))`

Regards.

This is pretty close but doesn't completely work.

Example: If you have a from and through date of 10/1/2018 to 12/31/2018 but you only have data that goes up to 12/15/2018, this will result in the max date being 12/15/2018 not 12/31/2018. If you wanted to use 12/31/2018 in a calcluation you couldn't.

Is there any way to just grab the date a user enters and use that date in another calculation, regardless of the data set that is returned?

Super User

Hi,

Assuming the Date slicer is built from a Calendar Table, try this measure

=Max(Calendar[Date])

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

Thank you @Ashish_Mathur ! It worked well.

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Perhaps something like:

`MyDate = MAX(Table[DateRec])`

@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper I

hi Greg,

I have used this logic but it gives me the max date of that column which is 5/7/2018 and completely ignores the selection.

Announcements

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors