Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to write a formula that will show me the last day of the month data, here is what I currently have:
{<Date ={"$(MonthStart(Min(Date))-1)"}>}
Please let me know what I should be doing differently for it to recognize it
Thanks!
Oh so you are looking to get month end value for each month on a line graph? Why not create a flag for this in the script
LOAD Date = Floor(MonthEnd(Date)) as Flag
and then this
Avg({<Flag = {'-1'}>}Goal)
Try this
{<Date = {"$(=MonthStart(Min(Date))-1)"}>}
or this
{<Date = {"$(=Date(MonthStart(Min(Date))-1))"}>}
Neither of those are working
What is your date field format?
M/DD/YYYY ex: 9/20/2017
How about this
Sum({<Date = {"$(=Date(MonthStart(Min(Date))-1, 'M/D/YYYY'))"}>} Measure)
Avg({<Date = {"$(=Date(MonthStart(Min(Date))-1, 'M/D/YYYY'))"}>} Goal)
its still not working, im using average, could this effect output?
It should not... can you share an image of the table where you add this as measure and hover over the expression header to show what the expression looks like? Make sure to now use any expression labels
the expression is: Avg({<Date = {"$(=Date(MonthStart(Min(Date))-1, 'MM/D/YYYY'))"}>} Goal)
hi
do you have month or date or year any date related field as dimension ?