Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |