March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I'm struggling with calculation that will show on card sum of values from last month by defeault or for selected months if they are selected. I don't have a problem with last month value and also everything works fine when I choose one month. but when I'm choosing two or more months I'm getting value just for last month in selection. for example if I choose Jan and Feb I will get value from Feb and I need to see Jan value plus Feb value.
my calculation:
Solved! Go to Solution.
Hi @lbendlin ,
Date | Sell |
01.01.2023 | 10 |
01.02.2023 | 12 |
01.03.2023 | 10 |
01.05.2023 | 11 |
My last month in example data is May. Goal is to see in the card last month sell by defeault when user open dashboard, for these case 11, but when user will choose different month card should include that , March 10.
it should also sum sale when user choose few months, for example February and March should give 22.
I know how to show all sum of all sale by deafult and then filtered months or how to show latest but don't know how to join both calculation in one.
Thank you
Marcin
Thank you @lbendlin,
Your calculation helped me a lot, but there was another isue, I had date filter (last 12 months) on whole page, that why even when I cleared the slicer card was showing "whole' sum of sales 🙂
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
148 | |
92 | |
72 | |
58 |