Forum Discussion
Replacing blank values with previous value in Matrix visual
Hi all,
I am trying to build a balance sheet using a matrix visual. I have a dax measure that calculates the running balance fine. However, when I put the data in a matrix visual, some columns appear as blanks. This could likely be due to there not being any transactions for the period. A snippet of the sample visual is as below
This being a balance sheet, I want the blank values to be filled with the non blank value from the previous period.
I have tried using the measure below but it is not working
The [BS_sum] is the running balance I created while the [account_id] is a column in a separate table that holds the names of the different ledger accounts.
Does anyone know how to fix this?
2 Replies
Hi Jason254,
You can use:
IF(ISBLANK([BS_sum]),CALCULATE([BS_sum],SAMEPERIODLASTYEAR('Date'[Date]))Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous ForecastsI have the same situation, I need to fill in the blanks with the last value found, I would greatly appreciate the support.
Best regards
