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.
Hi folks,
I need to calculate the past 12 months based on the max date. Please, any idea?
I try dateadd and it is not working.
Solved! Go to Solution.
Hi @claraigg ,
Dateadd is a table function and cannot be directly useful for metric values. You can see the results returned by the dateadd function by creating a calculated table.
You can try below formula:
M_ =
CALCULATE (
SUM ( 'Table 2'[value] ),
DATESBETWEEN (
'Table 2'[Date],
MAX ( 'Table 2'[Date] ) - 365,
MAX ( 'Table 2'[Date] )
)
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @claraigg ,
Dateadd is a table function and cannot be directly useful for metric values. You can see the results returned by the dateadd function by creating a calculated table.
You can try below formula:
M_ =
CALCULATE (
SUM ( 'Table 2'[value] ),
DATESBETWEEN (
'Table 2'[Date],
MAX ( 'Table 2'[Date] ) - 365,
MAX ( 'Table 2'[Date] )
)
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@claraigg 12_months = EOMONTH( [Max_sent_payment], -13) + 1
You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
@claraigg try the below
Past_12_Months_Start_Date = DATEADD(MAX('All Expenses'[Sent for Payment Date]), -12, MONTH)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Yeah, that was my first approach. However, it did not work.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |