@AmalrajRRD1 wrote:
Hi all,
I have month, Quarter and year colum. If i select month want to see latest month like July 2017 in text box, If i select Year i want to see like Jan 2017 to July 2017 (we have ten year data) . finally if i select quarter want to see Jan 2017 - mar 2017 (First quarter) also would like to see by quarter wise in text box ..
anyone can help me on this?
Thanks.
@AmalrajRRD1
I'd suggest to use a calendar table, when you'd like to show data for 2017, then pick up 2017 in the slicer. when to show data for Q1 2017, pick up Q1 in 2017. May I know why you don't like this way?
As to your requirement, there's some tricky way with complicated measures, the measures values could vary according to the slicer like
value =
SWITCH (
LASTNONBLANK ( yourFilter[YMQ], "" ),
"Month", CALCULATE (
SUM ( yourTable[col] ),
FILTER (
yourTable,
yourTable[date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY ), 1 )
)
),
"Quarter", CALCULATE (
SUM ( yourTable[col] ),
FILTER (
yourTable,
yourTable[date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY ), 1 )
&& CALCULATE (
SUM ( yourTable[col] ),
FILTER (
yourTable,
yourTable[date]
< DATE ( YEAR ( TODAY () ), MONTH ( TODAY ) + 3, 1 )
)
)
)
),
"Year", CALCULATE (
SUM ( yourTable[col] ),
FILTER ( yourTable, yourTable[date] >= DATE ( YEAR ( TODAY () ), 1, 1 ) )
)
)
