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 have a measure that counts the number of users by the date in the past 30 days, then also does the same for the previous month (31-60) and subtracts the 30 day count from the 31-60 count. From counting the raw data it doesn't that this is right, have I wrote it wrong?
Solved! Go to Solution.
Hi @analyst85 ,
I create a table as you mentioned but I have only ten days before.
Also I have a measure.
# Operations = SUM(Dates[Sum])
Then I do some changes on your DAX codes and it will give you the correct result. You can change the "31" to "30".
# Operations MoM Comparison =
CALCULATE(
[# Operations],
FILTER(
ALL('Dates'[FullDate]),
'Dates'[FullDate] >= TODAY() - 10 && 'Dates'[FullDate] <= TODAY() - 5
)
) -
CALCULATE(
[# Operations],
FILTER(
ALL('Dates'[FullDate]),
'Dates'[FullDate] >= TODAY() - 5 && 'Dates'[FullDate] <= TODAY()
)
)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @analyst85 ,
I create a table as you mentioned but I have only ten days before.
Also I have a measure.
# Operations = SUM(Dates[Sum])
Then I do some changes on your DAX codes and it will give you the correct result. You can change the "31" to "30".
# Operations MoM Comparison =
CALCULATE(
[# Operations],
FILTER(
ALL('Dates'[FullDate]),
'Dates'[FullDate] >= TODAY() - 10 && 'Dates'[FullDate] <= TODAY() - 5
)
) -
CALCULATE(
[# Operations],
FILTER(
ALL('Dates'[FullDate]),
'Dates'[FullDate] >= TODAY() - 5 && 'Dates'[FullDate] <= TODAY()
)
)
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @analyst85 ,
Can you please try below measure:
# Operations MoM Comparison =
CALCULATE(
[# Operations],
FILTER(
ALL('Dates'[FullDate]),
'Dates'[FullDate] > TODAY() - 61 && 'Dates'[FullDate] <= TODAY() - 30
)
) -
CALCULATE(
[# Operations],
FILTER(
ALL('Dates'[FullDate]),
'Dates'[FullDate] >= TODAY() - 29 && 'Dates'[FullDate] <= TODAY()
)
)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |