Forum Discussion
Last Values with contextual filters
- 3 years ago
Hello,
I solved my problem with the help of the following article:
https://exceleratorbi.com.au/fill-table-with-last-survey-result/
Then I needed to itterate the formula based on distinct values of the "Account" column. Chat GPT did this part for me!!
Hello,
I haven't managed to find the solution to this yet.
A ver similar thread I found in this forum: LASTNONBLANK Explained - Excelerator BI
but yet, they do not do the formula I need.
I've asked for help in that other forum also but no answer, if you can help in the meantime would be very much appreciated.
In that other forum example, the question would be:
" How should it be the formula if in addition to the current return values, I need to:
1. return values in those periods that there is no entry, i.e. to carry on the value from the previous period.
Example: May 2016, Kathy: 1,474 (rather than blank)
2. (Once point 1 is achieved) removing the “account” contextual filter so I can see the sum of all account balances at a moment in time.
e.g. balance for May 2016: 3,280 (1,474 from account “Kathy” and 1,806 from account “Matt”)
I’ve been trying to obtain this for many many hours and couldn’t manage to do it. I’m not an expert of DAX at all but couldn’t find anything clear about this despite I believe must be a usual application."
Thank you!
- miguelmkuk3 years agoFrequent Visitor
Hello,
I solved my problem with the help of the following article:
https://exceleratorbi.com.au/fill-table-with-last-survey-result/
Then I needed to itterate the formula based on distinct values of the "Account" column. Chat GPT did this part for me!!