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 April
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"
2 Replies
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"
Hello Anonymous ,
This can be accomplished by extracting the last day of the selected month
Using the following function combination:
test = day(EOMONTH(MAX('Table'[Date]),0))
Here is a picture for your convenience, as well as a link to a sample file.
https://drive.google.com/file/d/1Yl96_tsBjz6kWNMjDcmbjdCuCDavSaRU/view?usp=sharingDid I answer your question? Mark my post as a solution! Appreciate your Kudos !!
