Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
3 years ago
Solved

Quarter visual

I have a data set as show below.   I have a month dorpdown filter. When we select a month, i need the QTR for that month and the previous QTR in cards. and in another 2 card i need to show th...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

     

    Current Qtr = SELECTEDVALUE('Table'[Qtr])
-----
Last  QTR = 
VAR _selectQRT = SELECTEDVALUE('Table'[Order Qtr])-1
VAR _lastMonth = MAXX(FILTER(ALL('Table'),'Table'[Order Qtr]=_selectQRT),[Qtr])
RETURN
_lastMonth

     

unnijoy's avatar
unnijoy
Post Prodigy
3 years ago

Ahmedx  thanks for your qucik response. can you tell me how can i show the Quater name in a card. for example when i select April -23 the one card should show Q2'23 & in another card it should show the previous quarter as Q1'23.how can we do this.

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this

     

    Current Qtr = SELECTEDVALUE('Table'[Qtr])
-----
Last  QTR = 
VAR _selectQRT = SELECTEDVALUE('Table'[Order Qtr])-1
VAR _lastMonth = MAXX(FILTER(ALL('Table'),'Table'[Order Qtr]=_selectQRT),[Qtr])
RETURN
_lastMonth

     

    • unnijoy's avatar
      unnijoy
      Post Prodigy
      3 years ago

      Ahmedx  thank you very much. its working