Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to Solution.
Modification for previous year
CY Bookings Annualized =
CALCULATE (
SUM ( OrderLine[Booking USD] ),
YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ),
MONTH ( 'OrderLine'[Open_Date] ) <= MONTH ( TODAY()
)
)
PY Bookings Annualized =
CALCULATE (
SUM ( OrderLine[Booking USD] ),
YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ) - 1, -- Adjust for Previous Year
MONTH ( 'OrderLine'[Open_Date] ) <= MONTH ( TODAY()
)
)
Thank you very much! great help! how about MTD and QTD formula?
Modification for previous year
CY Bookings Annualized =
CALCULATE (
SUM ( OrderLine[Booking USD] ),
YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ),
MONTH ( 'OrderLine'[Open_Date] ) <= MONTH ( TODAY()
)
)
PY Bookings Annualized =
CALCULATE (
SUM ( OrderLine[Booking USD] ),
YEAR ( 'OrderLine'[Open_Date] ) = YEAR ( TODAY() ) - 1, -- Adjust for Previous Year
MONTH ( 'OrderLine'[Open_Date] ) <= MONTH ( TODAY()
)
)
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
119 | |
41 | |
40 | |
28 | |
22 |