The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
For a time calender I need the comparable 9distinct) last day of the quarter of the last quarter.
I am trying this, but not sure what neeeds to e changed:
Solved! Go to Solution.
Hi @acg
If you want to find the last day of the last quarter based on Today Date (or any specific date), you can use the below code:
CompareDateQuarter =
VAR _Today =
TODAY ()
RETURN
VAR _LastQuarter =
QUARTER ( _Today ) - 1
RETURN
VAR _LastQMonth = _LastQuarter * 3
RETURN
DATE ( YEAR ( _Today ), _LastQMonth + 1, 1 ) - 1
The output will be as below:
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Need to see, whether I can rework this with a dynamic quater date- in other words, it needs to work with any quarter date.
Hi @acg
If you want to find the last day of the last quarter based on Today Date (or any specific date), you can use the below code:
CompareDateQuarter =
VAR _Today =
TODAY ()
RETURN
VAR _LastQuarter =
QUARTER ( _Today ) - 1
RETURN
VAR _LastQMonth = _LastQuarter * 3
RETURN
DATE ( YEAR ( _Today ), _LastQMonth + 1, 1 ) - 1
The output will be as below:
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos !!
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |