Forum Discussion
Chitemerere
Responsive Resident
Responsive ResidentDates 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 🙂
Fowmy
Super User
Super User
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 🙂
ChitemerereResponsive Resident
Responsive ResidentHi 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