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.
Hello guys,
Need your help. I have an openingbalance but when there are no bookings during current year the row is not shown in the result.
For exemple:
For 01-01-2020 I have a filter to ignore all filters and only calculate on periode 0
Mutations during year are in periode 1-13
01-01-2020 | Debet | Credit | CALCULATE([01-01-2020]+ [Debet]+ [Credit]) |
14.000 | 1.000 | -1.000 | 14.000 |
15.000 | 0 | 0 | 15.000 |
The problem is that when I filter with period 0 the 01-01-2020 is correct, but debet and credit also have the total of period 0, but when I filter period 1 the second row dissapears.
Totals don't change.
How can I make sure that if there are no mutations during the year, that all the rows from calculation 01-01-2020 stay visable?
Thank you for your help.
@Sparkeltje , Your table is not very clear. Typically we add +0 to a measure or use this option to show all data from a dimension
@amitchandak, I tried +0 but then my first two column gets messed up. Try to make it clear
ACCOUNT | DESCRIPTION | OPENING BALANCE | MUTATIONS DURING YEAR DEBIT | MUTATIONS DURING YEAR CREDIT | CLOSING BALANCE |
01004 | ASSETS | 783.980.073,84 | 601.956,48 | -14.669,51 | 784.567.360,81 |
01005 | DEPRECIATION | -353.337.231,51 | 0 | -23.628.688.57 | -376.965.920,08 |
11101 | TAXES | 136815,02 | 1.155.215,56 | -1.195.091.28 | 96.939.30 |
23002 | OPTIONS | 530.283,40 | 0 | 0 | 530.283,40 |
30000 | STOCK | 2.282,50 | 6.782,50 | 3.235,00 | 5.830,00 |
OPENING BALANCE IS PERIOD 0 > with FILTER ALL I ingnore filters on the sheet which are: MUTATIONS IS PERIOD 1-13
BUT WHEN I FILTER 1-13 (and leave PERIOD 0 out of it), the table will be as follow, row 23002 OPTIONS dissapears because there are no mutations this year.
ACCOUNT | DESCRIPTION | OPENING BALANCE | MUTATIONS DURING YEAR DEBIT | MUTATIONS DURING YEAR CREDIT | CLOSING BALANCE |
01004 | ASSETS | 783.980.073,84 | 601.956,48 | -14.669,51 | 784.567.360,81 |
01005 | DEPRECIATION | -353.337.231,51 | 0 | -23.628.688.57 | -376.965.920,08 |
11101 | TAXES | 136815,02 | 1.155.215,56 | -1.195.091.28 | 96.939.30 |
30000 | STOCK | 2.282,50 | 6.782,50 | 3.235,00 | 5.830,00 |
When I use + 0 the following happens
ACCOUNT | DESCRIPTION | OPENING BALANCE | MUTATIONS DURING YEAR DEBIT | MUTATIONS DURING YEAR CREDIT | CLOSING BALANCE |
01004 | ASSETS | 783.980.073,84 | 601.956,48 | -14.669,51 | 784.567.360,81 |
01004 | DEPRECIATION | 0 | 0 | 0 | 0 |
01004 | TAXES | 0 | 0 | 0 | 0 |
01004 | OPTIONS | 0 | 0 | 0 | 0 |
01004 | STOCK | 0 | 0 | 0 | 0 |
01004 | ASSETS | 0 | 0 | 0 | 0 |
01005 | DEPRECIATION | -353.337.231,51 | 0 | -23.628.688.57 | -376.965.920,08 |
01005 | TAXES | 0 | 0 | 0 | 0 |
01005 | OPTIONS | 0 | 0 | 0 | 0 |
01005 | STOCK | 0 | 0 | 0 | 0 |
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |