Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |