Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi Community!
I want to get average value in the past month.
Anyone knows how to do this using Dax?
For example, I have a database like this:
Let's assume today date is 2022/11/09. So for the past month average value should be A124, A125, A126 models average duration.
the answer will be 432 + 322 + 100 / 3 = 854 = 284.5
Anyone know how to implement this average value during the past 1 month?
Thank you so much for your help!
Thanks,
Jean
Solved! Go to Solution.
Hi @heejinyune ,
Please try:
Measure = CALCULATE(AVERAGE('Table'[Model Built Duration [Mins]]]),FILTER('Table',[Model Built Date]>=EDATE(TODAY(),-1)&&[Model Built Date]<=TODAY()))
Note: today is 2022/11/14, so the average is :(322+100)/2 = 211
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @heejinyune ,
Please try:
Measure = CALCULATE(AVERAGE('Table'[Model Built Duration [Mins]]]),FILTER('Table',[Model Built Date]>=EDATE(TODAY(),-1)&&[Model Built Date]<=TODAY()))
Note: today is 2022/11/14, so the average is :(322+100)/2 = 211
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@heejinyune Try:
Measure =
VAR __Date = MAX('Table'[Date])
VAR __Year = YEAR(__Date)
VAR __Month = MONTH(__Date)
VAR __Table = FILTER(ALL('Table'),YEAR([Date]) = __Year && MONTH([Date]) = __Month)
VAR __Return = AVERAGEX(__Table,[Model Built Duration [Mins])
RETURN
__Return
User | Count |
---|---|
64 | |
55 | |
46 | |
31 | |
31 |
User | Count |
---|---|
84 | |
73 | |
52 | |
48 | |
43 |