Forum Discussion

xiumi_hou's avatar
xiumi_hou
Post Partisan
6 years ago
Solved

How to extract out filter date?

Hi All,

 

How can I extract out filter date to text: From XXX to XXX  Thanks.

  • By creating text a measure with the appropriate formatting:

    Date Range = "From " & Format( MIN( 'Date'[Date] ) , "yyyy-mm-dd") & " to " & Format( MAX( 'Date'[Date] ) , "yyyy-mm-dd")

1 Reply

  • By creating text a measure with the appropriate formatting:

    Date Range = "From " & Format( MIN( 'Date'[Date] ) , "yyyy-mm-dd") & " to " & Format( MAX( 'Date'[Date] ) , "yyyy-mm-dd")