Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Hi @Rahulsingh,
Use this formula:
Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))
Regards.
Hi @Rahulsingh,
Use this formula:
Date_Selected = CALCULATE(MAX(Date_Table[DateRec]);ALLSELECTED(Date_Table))
Regards.
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?
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 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?
Hi,
Assuming the Date slicer is built from a Calendar Table, try this measure
=Max(Calendar[Date])
Hope this helps.
You are welcome.
Perhaps something like:
MyDate = MAX(Table[DateRec])
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
68 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
88 | |
49 | |
45 | |
38 | |
37 |