Forum Discussion
In a matrix, how I can replace values in empty cells with values of previous cells ?
mape,
You have to understand the solution, the following DAX is built on MM/DD/YYYY date format field so to make it easier follow the link to my Power BI library and download the solution =D
Hope this helps and will explain how it works.
Regards
Abduvali
Hi Abduvali
That is fantastic!! thank you, now it works, I was creating a calculated column instead of a measurement.
I have a new doubt, if I wanted to do it for the months, would it work the same way? , for example, if call ustomers all have sales in May but in November only some customer have it, and I want those that are blank in November to show me the May sales, how would it be in this case?
:)
- mape8 years agoFrequent Visitor
Hi @Abduvali
That is fantastic!! thank you, now it works, I was creating a calculated column instead of a measurement.
I have a new doubt, if I wanted to do it for the months, would it work the same way? , for example, if call ustomers all have sales in May but in November only some customer have it, and I want those that are blank in November to show me the May sales, how would it be in this case?