Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have the accumulated balance of an account. For example, season 16-17. When I use a filter and filter for season 16-17, the balance that appears is that of that period and what I would like is that the accumulated balance.
Is this possible to do? If possible, how can it be done?
Thank you very much and regards.
Solved! Go to Solution.
@Anonymous,
Please check if the following DAX returns your expected result.
Saldo running total in Mes = CALCULATE( SUM('Diario1'[Saldo]), FILTER( ALLSELECTED('Calendario'[Fecha]), Calendario[Fecha]<=MAX(Calendario[Fecha]) ) )
Regards,
you would need a date or a sequence number like an index to accumulate the data. Are the seasons linked to dates?
Proud to be a Super User!
Hello,
Seasons are associated with dates. There is a table that shows the relationship between dates and seasons.
Thank you very much for your help.
@Anonymous,
You can follow the instructions in the blog below to create cumulative total. If you need exact DAX for your scenario, please help to share sample data of the two tables and post the relationship between the two tables.
http://www.daxpatterns.com/cumulative-total/
Regards,
Lydia
Hello Lydia,
The information that has passed me is very interesting and valuable.
In my case, it is not to get the accumulated, which I have already achieved, but when I use a slicer shows me the difference of the accumulated period that I frame with the previous period and what I want is to show the accumulated until the period marked.
Thank you very much and best regards.
@Anonymous,
What formula do you use to create accumulated balance? Could you please post raw data of your tables or PBIX file so that I can test?
Regards,
Hello,
The formula I have used is the one created by the quick measures which is the following:
Saldo acumulado =
CALCULATE(
'ACCOUNT_INFORMATION'[ACTIVO];
FILTER(
CALCULATETABLE(
SUMMARIZE(
'CALENDAR';
'CALENDAR'[NumTemporada];
'CALENDAR'[Temporada]
);
ALLSELECTED('CALENDAR')
);
ISONORAFTER(
'CALENDAR'[NumTemporada]; MAX('CALENDAR'[NumTemporada]); DESC;
'CALENDAR'[Temporada]; MAX('CALENDAR'[Temporada]); DESC
)
)
)
Thank you very much
@Anonymous,
Could you please share sample data of your original tables?
Reagrds,
Lydia Zhang
Hello Lydia,
Data table
Balance table
And here you can see the relationship between the different tablesThank you very much ande best regards.
@Anonymous,
I don't see the ACTIVO field in your data table, and I am not sure which fields you use to create relationship between the tables. Would you mind sharing me the PBIX file via Private message and post expected result in a table so that I can provide you appropriate DAX?
Regards,
@Anonymous,
Please refer to https://community.powerbi.com/t5/Welcome-to-the-Community/How-to-send-private-messages/td-p/232.
Also ensure that you send expected result to me.
Regards,
Hello Lydia,
I do not know how to insert the file into the message. How can you insert it?
Sorry for the inconvenience.
Thank you very much and best regards.
@Anonymous,
You can upload PBIX file to OneDrive and post shared link of the file via Private message.
Regards,
Did you see the file I shared privately with you?
Thank you very much and best regards.
@Anonymous,
Please check if the following DAX returns your expected result.
Saldo running total in Mes = CALCULATE( SUM('Diario1'[Saldo]), FILTER( ALLSELECTED('Calendario'[Fecha]), Calendario[Fecha]<=MAX(Calendario[Fecha]) ) )
Regards,
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
142 | |
76 | |
63 | |
51 | |
47 |
User | Count |
---|---|
214 | |
84 | |
61 | |
61 | |
60 |