Dynamic title Question

[Anonymous]

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 

[Ritaf1983]

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=sharing 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[amitchandak · Accepted solution]

@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"