Forum Discussion
Closing value
- 4 months ago
Hi rajasekaro,
Please have a look at the below solution.1) Create power Bi measures for the closing
ClosingV3 = VAR Opening = MAX(account_transactions[APYC]) VAR CurrentDate = MAX(account_transactions[DATE]) VAR CurrentAccount = MAX(account_transactions[ACCOUNT]) VAR CumulativeAmount = CALCULATE( SUM(account_transactions[AMOUNT]), REMOVEFILTERS(account_transactions), account_transactions[ACCOUNT] = CurrentAccount, account_transactions[DATE] <= CurrentDate ) RETURN Opening + CumulativeAmountOR
Closing_v4 = VAR Opening = MAX(account_transactions[APYC]) RETURN Opening + CALCULATE( SUM(account_transactions[AMOUNT]), ALLEXCEPT(account_transactions, account_transactions[ACCOUNT]), account_transactions[DATE] <= MAX(account_transactions[DATE]) )2) Copy that measure in the table/matrix visual
Please consider as an accepted solution if worked or give some kudod.
- 4 months ago
if you want to create a column ,you can try this
Column = 'Table'[APYC]+sumx(FILTER('Table','Table'[ACCOUNT]=EARLIER('Table'[ACCOUNT])&&'Table'[DATE]<=EARLIER('Table'[DATE])),'Table'[AMOUNT])
Hi rajasekaro,
Please have a look at the below solution.
1) Create power Bi measures for the closing
ClosingV3 =
VAR Opening = MAX(account_transactions[APYC])
VAR CurrentDate = MAX(account_transactions[DATE])
VAR CurrentAccount = MAX(account_transactions[ACCOUNT])
VAR CumulativeAmount =
CALCULATE(
SUM(account_transactions[AMOUNT]),
REMOVEFILTERS(account_transactions),
account_transactions[ACCOUNT] = CurrentAccount,
account_transactions[DATE] <= CurrentDate
)
RETURN
Opening + CumulativeAmountOR
Closing_v4 =
VAR Opening = MAX(account_transactions[APYC])
RETURN
Opening +
CALCULATE(
SUM(account_transactions[AMOUNT]),
ALLEXCEPT(account_transactions, account_transactions[ACCOUNT]),
account_transactions[DATE] <= MAX(account_transactions[DATE])
) 2) Copy that measure in the table/matrix visual
Please consider as an accepted solution if worked or give some kudod.
Hi rajasekaro ,
Thank you for reaching out to the Microsoft Community Forum. could you please try the proposed solution shared by Lodha_Jaydeep ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
- v-dineshya4 months ago
Community Support
Hi rajasekaro ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh