Dates Between in Smart Narrative Measure

[Chitemerere]

I am creating a Smart Narrative from scratch using a text box as follows:

I need the narrative give the dates between average daily sales calculation as circled above.  How can the dates be generated using DAX.  I tried the following for the first date:

 but this does not give the first date, it gives the selected value date in the graph instead of the start date in the graph series which is 01/01/2007.

Kindly assist,

Chris

[Fowmy · Accepted solution]

@Chitemerere 

To get the first and last date within the graph :

First Date  = Calculate(min(factdate(date), allselected(factdate(date))
Last Date  = Calculate(max(factdate(date), allselected(factdate(date))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Chitemerere]

Hi Fowmy

I had to change the above to "ALL" instead of "ALLSELECTED" as "ALLSELECTED" gave date value changes in my tool tip with changes in Dates in my graph

[Chitemerere]

Thank you very much Fowmy, that worked like magic.

Best regards,

Chris