repeat last record for future sales

[eheres]

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 formula that im doing wrong. Can you help me please

Here is the data, thats what i got

Product	Sales Rep Sic	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22
CXR	Moira	-	-	-	-	-	-	-	-	-	-	-	-	-	1	-	-
CXR	Fernanda	-	6	6	6	5	5	5	5	4	3	2	2	2	-	-	-
CXR	Raul	6	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
CX20	John								25	25	25	25	25	25
CX20	Andre	25	25	25	25	25	25	25

Thats what i need

Product	Sales Rep Sic	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22
CXR	Moira	-	-	-	-	-	-	-	-	-	-	-	-	-	1	1	1
CXR	Fernanda	-	6	6	6	5	5	5	5	4	3	2	2	2	-	-	-
CXR	Raul	6	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
CX20	John								25	25	25	25	25	25	25	25	25
CX20	Andre	25	25	25	25	25	25	25	-	-	-	-	-	-	-	-	-

Thank you!

[Whitewater100]

Hi:

It looks the same. If true you can duplicate the table either in DAX or Power Query.

For DAX go to Modeling> New Table 

New Table = 'First Table'

I hope this helps!

[eheres]

Hi Thank you, but they are not the same table, the last 2 months have amounts and the first one is not

[Whitewater100 · Accepted solution]

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 

[eheres]

Thank you!! can you send me the dax? the google drive is not working

[Whitewater100]

Hi:  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..

[Whitewater100]

Where it says 'First Table' that is the name of your current table....