Forum Discussion
In a matrix, how I can replace values in empty cells with values of previous cells ?
Hi Abduvali , sorry for my english, I think that we don't speak about the same.
Assuming there is only one sale per year per customer and in some cases if there is not one I want to take the previous year, I do not care about the date, month, day ... only the year. It keeps showing me what we are talking about, removing the rest of the elements from the date hierarchy
Look the image:
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?:)
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?