Dear all bros,
I have the case as below and need your help.
above table show the staff per department: for sales they have 10 staff on jan 2020 and before time, the staff amount unchange untill may 2020 is 8. the same explain for cs department.
so i need the table like
jan 2020 sales 10
feb 2020 sales 10
may 2020 sales 8
march 2021 sales (Still ) 8
I need the table as above to count the order per sales.
any recomend to do like this
thank you for reading and help
Go to Solution.
Please kindly check if the below picture is what you are looking for.
if not, please let me know.
I created a custom-date-table and connected it to the main table.
Each month is pulling the information that is the staff count, and if it is blank, then it looks for the previous nonblank value.
the link to the sample pbix file is down below.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!!
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Best regards, JiHwan Kim
View solution in original post
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!