Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
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!
Hi Thank you, but they are not the same table, the last 2 months have amounts and the first one is not
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
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])
Where it says 'First Table' that is the name of your current table....
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |