I would like to convert the annual sales forecast into the monthly sales forecast which added the start and end times.
How can I do like this?
Solved! Go to Solution.
Dear @Ashish_Mathur,Thank you your PBI file.
I have a question.
There is no 'date' in the original data table.
How do I get dates in the data table?
In your original screenshot, there are 2 date columns - Start and End.
Sorry! I have one more question.
When I made custom columns and deleted duplicates, required IDs were deleted as well.
How can I delete only the duplicate date, leaving the required ID?
You have to select all the columns and then remove duplicates
You have to select all columns > right click and then select Remove Duplicates.
I really do not know why. It worked absolutely fine for me.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!