Forum Discussion
Solved
Dates Between in Smart Narrative Measure
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...
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 š
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 š
Thank you very much Fowmy, that worked like magic.
Best regards,
Chris
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
