Forum Discussion
Solved
repeat last record for future sales
Hi Everyone, Hope you can help me, I got some units by month, sales manager and type of product. But the thing is that i need to repeat the last record by sales manager, i know that is only a dax...
Yes, I see. Sorry about that.
Please find link for last value. I had to rearrange the data to get in table form for Power BI.
https://drive.google.com/file/d/14-t-gm8lVliFbp9o8Ebphf6r9KJ2fgQj/view?usp=sharing
Thank you!! can you send me the dax? the google drive is not working
Whitewater100
Solution Sage
Solution SageHi: Yes, DAX below.
I first loaded a table that looks like yours. Then in Power Query I did some steps. Here they are:
This gave me a table that looks like this (4 columns)
Total Amount = SUM(SalesTable[Amount])
Last Value = LASTNONBLANKVALUE(Dates[Date],[Total Amount])
if this answer is good for you, can you check it as solved? Thank you..