Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
@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.
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 ) ) ) )
@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.
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 ) ) ) )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |