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 guys
I have many rows, with the account, account description, debits, credits, and the initial balance and the final balance, so my query for the initial balance is:
Solved! Go to Solution.
@yingyinr Hi, I fixed it with:
Kind regards
Eduardo Silva
@Anonymous
You might want to explore the functions available, such as OPENINGBALANCEMONTH
https://dax.guide/openingbalancemonth/
Proud to be a Super User!
Paul on Linkedin.
@PaulDBrown thank you Paul, but how could I applied it if I could filtered by different periods of time
(account - open balance - debits - credits - final balance)
Hi @Anonymous ,
I'm sorry that I still have some confusion about your requirement. Could you please provide more sample data and explain your problem&desired result with specific data examples? And could you please list the fields/measures which applied in Matrix and slicer? Are they from the same table?
My problem is when I filter for dates, if the last movement of the the account "xx-xx-xx" was on april 2019, and in 2020 I don't have any movements, it will never be shown with this filter. How could I indicate that I want to continue showing the accounts with the final balance <>0, in order to have the real balance in each filtered period?
Best Regards
Rena
@yingyinr Hi, I fixed it with:
Kind regards
Eduardo Silva
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak hey, sure:
for example, this account is an asset, when I filter by date, selecting 2019, everything is ok, because my date for this row is 2019, but when I filter any month or the complete year 2020, the problem is that the system doesnt found that account in those dates and my sum of assets doesnt take that account.
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |