Forum Discussion
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 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!
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
6 Replies
Whitewater100Solution Sage
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!
- Whitewater100
Where it says 'First Table' that is the name of your current table....
Hi Thank you, but they are not the same table, the last 2 months have amounts and the first one is not
- Whitewater100
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
