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 All,
I am traying to create a column that calculates the opening balance based on the minimum slicer value. Bascially I need either a measure/calculated column that says if the date on my transaction in less then the lowest slicer date then output Time+disburs+invoiced+write-on else return zero. This is then what will be used to calculate my closing WIP balance. So far I have got;
@Breardon , better to use a date table .
Opening = calculate(sumx(Append1,Append1[Time])+sumx(Append1,Append1[Disburs])+sumx(Append1,Append1[Invoiced])+sumx(Append1,Append1[Write-on])
filter(all(Append1[Date]), Append1[Date]<[Min date]))
or
Opening = calculate(sumx(Append1,Append1[Time])+sumx(Append1,Append1[Disburs])+sumx(Append1,Append1[Invoiced])+sumx(Append1,Append1[Write-on])
filter(all(Append1), Append1[Date]<[Min date]))
or
Opening = calculate(sumx(Append1,Append1[Time])+sumx(Append1,Append1[Disburs])+sumx(Append1,Append1[Invoiced])+sumx(Append1,Append1[Write-on])
filter(all(Append1[Date]), Append1[Date]<[Min date]))
or
Opening = calculate(sumx(Append1,Append1[Time])+sumx(Append1,Append1[Disburs])+sumx(Append1,Append1[Invoiced])+sumx(Append1,Append1[Write-on])
filter(all(Date), Date[Date]<[Min date]))
Thanks for that! So close - still throwing zeros! I tried with the date table too..
Hi @Breardon ,
Can you please share some sample data and your expected results? We are not clear just based on a matrix screenshot. Please share more details with us. Thanks!
Hi All,
Ive done some more work to the file and have found that if there is no transaction after the opening date and before the closing date then the opening date visual doesnt show nor is it included in the closing balance calculations.
For example, the opening balance for example company 1 should be 66.67 when the opening date is set to 30/04/2020. However, when the closing date is anything before 05/05/2020 it removes it from the visual/ from the calculation in the closing balance measure.
Please see attached link to the file. https://drive.google.com/drive/folders/1Bq-_g5rQg4txyHPM1IiC3sudyznj7f0j?usp=sharing
Hi All,
Has anyone been able to figure out my problem?
Thanks
@Breardon , Can you share sample data and sample output in table format?
Is this what you were after?
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 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |