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

     

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