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'm trying to see some growth numbers comparing this months year vs last months year. These aren't values so I'm using COUNT:
To get values for the previous year, I created this measure:
However, it doesn't seem to work. Does anyone know what I'm doing wrong?
My end goal is to have the growth numbers displayed by month
Thanks!
Solved! Go to Solution.
Hi @Anonymous,
For each month in the bar chart, the filter context only contains dates of currently month.
So add REMOVEFILTERS() to your measure. Or some other functions like ALL(), ALLEXCEPT(), ALLSELECTED().
processed report last month =
CALCULATE(
[processed report this month],
PREVIOUSMONTH( 'Table'[Date] ),
REMOVEFILTERS()
)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
For each month in the bar chart, the filter context only contains dates of currently month.
So add REMOVEFILTERS() to your measure. Or some other functions like ALL(), ALLEXCEPT(), ALLSELECTED().
processed report last month =
CALCULATE(
[processed report this month],
PREVIOUSMONTH( 'Table'[Date] ),
REMOVEFILTERS()
)
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
PARARRELPERIOD with the settings you have returns the value from last month. To get LY you can use e.g. PREVIOUSYEAR. e.g. CALCULATE([Measure],SAMEPERIODPREVIOUSYEAR('Calendar'[Date])).
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi,
Thank you. It looks like I'm getting values which is great but the values are exactly the same:
Would you know what I'm doing wrong here?
Hi,
Are you using date column from your calendar in your visualization? Also what kind of relationship do you have between your calendar and fact table?
Proud to be a Super User!
Hi, I'm using my month name from my data table
Here is the relationship between both tables
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |