Forum Discussion
Last date value - lastnonblank doesn't working
Hello everyone I have a big trouble with dax. I have some data with some blank rows for some months. If the value for month is blank i would like to get a value from previous time (month, week etc.)...
It is incorrect in more than one products, these is my sample of Data
I made it in real data by crossjoin products and SortID, I have a lot of products, so It is very very difficult to do
Hi KVPro ,
It's easier to achieve in Power Query Editor.
1.Right click Product column, select group by. In operation, select All Rows.
2.Add a custom column.
= Table.FillDown([Count],{"Real Values"})
3.Remove the Count column and expand the Custom column.
4.Replace null with 0.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Table has been created crossjoin some tables in DAX, so I cannot do it in PowerQuery and I have to use dax functions 😞