Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hello everyone,
.
So in my Report I use two slicers one for the MONTH (1,2,3,4 ....12) and the other one for YEAR (2014, 2015 .... 2020). So I want to create a measure that when I choose the month & year from the slicer it returns the 01st of the following month.
Example
MONTH = 7 (selected from a slicer)
YEAR = 2015 (selected from a slicer)
Measure returns = 01/08/2015 in date format.
Thanks in advance 🙂
EDIT: The correct syntax is :
Measure = EDATE(DATE(SELECTEDVALUE(Slicer[Year], SELECTEDVALUE(Slicer[Month]),1),1)
Solved! Go to Solution.
Hi @Anonymous
Measure =
DATE ( SELECTEDVALUE ( SlicerT[Year] ), SELECTEDVALUE ( SlicerT[Month] ), 1 )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi,
If the month and year are from the Calendar Table, then try this measure
=max(calendar[Date])+1
Hi @Anonymous
Measure =
DATE ( SELECTEDVALUE ( SlicerT[Year] ), SELECTEDVALUE ( SlicerT[Month] ), 1 )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
The correct syntax is:
Measure = EDATE(DATE(SELECTEDVALUE(Slicer[Year], SELECTEDVALUE(Slicer[Month]),1),1)
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.