The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear, Good afternoon, i'm breaking my head with this problem, i need to calculate the balance stock with last amount by product by inventory, my data model is:
Date Product Amount Inventory
02/01/2018 1,00 1119 801
08/01/2018 1,00 1120 801
09/01/2018 1,00 1110 801
10/01/2018 1,00 1111 801
I'de like that result stay like this with amount by day:
Date Product Amount Inventory
02/01/2018 1,00 1119 801
03/01/2018 1,00 1119 801
04/01/2018 1,00 1119 801
05/01/2018 1,00 1119 801
06/01/2018 1,00 1120 801
07/01/2018 1,00 1120 801
08/01/2018 1,00 1120 801
09/01/2018 1,00 1110 801
10/01/2018 1,00 1111 801
i made this formula but the result don't work with i'de, someone have any idea ?
amountCurrent =
VAR ultimoValor = CALCULATE(
SUM('public f_saldo_historico'[amount]);
FILTER(
'public d_data';
MAX('public f_saldo_historico'[date]) = 'public d_date'[date]
)
)
Solved! Go to Solution.
Hi @Jonathas,
Please download the demo from the attachment.
Measure = VAR stopDate = CALCULATE ( MAX ( 'public f_saldo_historico'[Date] ), ALL ( 'public d_date' ), ALL ( 'public f_saldo_historico' ) ) VAR lastMaxDate = CALCULATE ( MAX ( 'public f_saldo_historico'[Date] ), FILTER ( ALL ( 'public d_date'[Date] ), 'public d_date'[Date] <= MAX ( 'public d_date'[Date] ) ) ) RETURN IF ( MAX ( 'public d_date'[Date] ) <= stopDate, CALCULATE ( MAX ( 'public f_saldo_historico'[Amount] ), FILTER ( ALL ( 'public d_date'[Date] ), 'public d_date'[Date] = lastMaxDate ) ) )
Best Regards,
Dale
Hi @Jonathas,
Please download the demo from the attachment.
Measure = VAR stopDate = CALCULATE ( MAX ( 'public f_saldo_historico'[Date] ), ALL ( 'public d_date' ), ALL ( 'public f_saldo_historico' ) ) VAR lastMaxDate = CALCULATE ( MAX ( 'public f_saldo_historico'[Date] ), FILTER ( ALL ( 'public d_date'[Date] ), 'public d_date'[Date] <= MAX ( 'public d_date'[Date] ) ) ) RETURN IF ( MAX ( 'public d_date'[Date] ) <= stopDate, CALCULATE ( MAX ( 'public f_saldo_historico'[Amount] ), FILTER ( ALL ( 'public d_date'[Date] ), 'public d_date'[Date] = lastMaxDate ) ) )
Best Regards,
Dale
@v-jiascu-msft I hava a new problem, when i select more than product, the total stay mistake, because it do not consider the total by product, can you help me
?different result
Hi @Jonathas,
I can't see a total in your image. I just see two records (rows). I would suggest you create a new post in this forum with a sample and the formula you used.
Best Regards,
Dale