Forum Discussion
Dynamic title Question
How do you make the title card dynamic where insteading of stating "Last Month" it would say last 28 days (For Feb) in March but this would change to last 31 days in 2 weeks time (for March) in Apr...
Anonymous , Assume the month selection is coming from a date table or today
Measure =
var _max = day( eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0))
return
"Last " & _max & " Days"
amitchandak
Super User
Super UserAnonymous , Assume the month selection is coming from a date table or today
Measure =
var _max = day( eomonth(if(isfiltered('Date'),MAX( 'Date'[Date]) , today()),0))
return
"Last " & _max & " Days"