Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
Below expression working fine , it will return "Apr-Jun 22":-
Solved! Go to Solution.
Hi @Paulyeo11 ,
How about this:
Qtr Current = VAR startdate = EDATE ( TODAY (), - 0 ) VAR enddate = DATE ( MAX ( 'DATE'[Year2] ), MONTH ( TODAY () ) +2 , 1 ) RETURN "Q" & FORMAT(startdate, "q") & "-" & FORMAT(startdate, "yy")
Let me know if this works 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @Paulyeo11 ,
How about this:
Qtr Current = VAR startdate = EDATE ( TODAY (), - 0 ) VAR enddate = DATE ( MAX ( 'DATE'[Year2] ), MONTH ( TODAY () ) +2 , 1 ) RETURN "Q" & FORMAT(startdate, "q") & "-" & FORMAT(startdate, "yy")
Let me know if this works 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Your expression working e fine ,
thank you very much.
my next question is , when i the month of may and june , will your expression still display Q2-22 ?
Paul
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |