Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello wizards of PBI! I need some help with a dax measure.
I want to have a card at the bottom of the page outputting the date range selected.
Something like: "first month" - "last month", which would output Feb-Apr etc
I would also like it to only output 1 month if only 1 is selected.
I've never really messed around with adding text in this way. Is it possible?
Solved! Go to Solution.
@StefanM, try this measure:
Label Period Selected =
VAR vStartDate =
MIN ( 'Date'[Date] )
VAR vEndDate =
MAX ( 'Date'[Date] )
VAR vYear =
YEAR ( vEndDate )
VAR vStartMonth =
FORMAT ( vStartDate, "mmm" )
VAR vEndMonth =
FORMAT ( vEndDate, "mmm" )
VAR vMonthLabel =
IF ( vStartMonth = vEndMonth, vEndMonth, vStartMonth & " - " & vEndMonth )
VAR vResult =
vYear & " " & vMonthLabel
RETURN
vResult
Display the measure in a card:
Proud to be a Super User!
@StefanM, try this measure:
Label Period Selected =
VAR vStartDate =
MIN ( 'Date'[Date] )
VAR vEndDate =
MAX ( 'Date'[Date] )
VAR vYear =
YEAR ( vEndDate )
VAR vStartMonth =
FORMAT ( vStartDate, "mmm" )
VAR vEndMonth =
FORMAT ( vEndDate, "mmm" )
VAR vMonthLabel =
IF ( vStartMonth = vEndMonth, vEndMonth, vStartMonth & " - " & vEndMonth )
VAR vResult =
vYear & " " & vMonthLabel
RETURN
vResult
Display the measure in a card:
Proud to be a Super User!
This works brilliantly. The only part I've left to do is to display another year for when the first month is from a different year, but with your easy to follow formula, I don't think that won't be a problem ^^
Thanks a lot @DataInsights 👍
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |