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 there,
I have a measure that calculates the cumulative sum until the end of last month. The measure looks like as follow:
However, if I use the same measure in the card visual, it shows blank:
I noticed that If I remove the colored text from the below measure then it works fine. However, the calculation is different as it starts considering the current month (after removing the colored text). Did someone encounter the same problem? Any help to fix the issue would be really appreciated.
@Dunner2020 , Formula seem correct , try this one
cumulative sum =
var lastmonth =EOMONTH(TODAY(),-1)
Return
sumx(FILTER(ALL('Outages'),'Outages '[Actual Interruption Start Date Time]<=MAX('Outages '[Actual Interruption Start Date Time]) && 'Outages '[Actual Interruption Start Date Time ] <=lastmonth),
[sum_measure])
@amitchandak Thanks for the response, I tried your suggested one. Following is the output for the new formula
As you can see it starts showing the value of the Current month (i.e. October) and next month (i.e. November). However, it started showing value on the card visual. As I mentioned in my actual post that this cumulative measure shows the cumulative sum until the end of last month. Don't want to show the current and next month.
Hello, @leo_89
According to its description, the measure shows the same value as September in October and November. I suggest you use the page filter to filter the months you want to display, and 10,11,12 months will disappear on the chart as well:
Best regards
Qin Community Support _Robert Team
If this post helps,then consider Accepting it as the solution to help other members find it faster.
@Dunner2020 , As you have not selected any date on page that is why is showing null on card . Because your formula does not go beyond current month.
Your formula is correct. You need to have filter to see data on card
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |