Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Instead of hardcoding, is it possible to set last 12 months for dimension.
If condition
=If(CREATED_DATE>=Date#('10/01/2016','MM/DD/YYYY'),MonthName(CREATED_DATE))
or
set Analysis for last 12 months
Dimension: CREATED_DATE
Measure: (Count(DISTINCT {<_Source={'A'}>}[ID1]) + Count(DISTINCT {<_Source={'B'}>} ID2))
may be this
=If(CREATED_DATE>=Date(monthstart(addmonths(today(),-12)),'MM/DD/YYYY'),MonthName(CREATED_DATE))
edit: left s in add months . corrected it
regards
Pradosh
What date this is ? 10/01/2016
may be this
=If(CREATED_DATE>=Date(monthstart(today()),'MM/DD/YYYY'),MonthName(CREATED_DATE))
need to set last one year in dimension(10/01/2016) MM/DD/YYYY,
may be this
=If(CREATED_DATE>=Date(monthstart(addmonths(today(),-12)),'MM/DD/YYYY'),MonthName(CREATED_DATE))
edit: left s in add months . corrected it
regards
Pradosh