Forum Discussion
In a matrix, how I can replace values in empty cells with values of previous cells ?
Hi everyone!! I need help about this... Measure of sales per year and in case there is no information for that year, show the sales of the previous year. That is, given a series of sales per ...
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