Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi
I was half way done with DAX calculated column but i need help in calculating the rolling 12 months from previous complted month which i was not able to figure it out . can you please help here ?
what i was able to figure it out is rolling 12 months from today using below formula .can anyone help with previous completed month to rolling 12 months back from today will work for me .
Solved! Go to Solution.
@Anonymous ,
You may modify your measure as below:
Last12Months = VAR LDATE = TODAY () VAR FDATE = EOMONTH ( LDATE, -13 ) + 1 RETURN IF ( Query1[BATCHDATE] < LDATE && Query1[BATCHDATE] >= FDATE, "True", "False" )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
You may modify your measure as below:
Last12Months = VAR LDATE = TODAY () VAR FDATE = EOMONTH ( LDATE, -13 ) + 1 RETURN IF ( Query1[BATCHDATE] < LDATE && Query1[BATCHDATE] >= FDATE, "True", "False" )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |