Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
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?
Hi,
In your original screenshot, there are 2 date columns - Start and End.
Sorry!
I did not notice the custom column.
Thank you!
You are welcome.
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?
Hi,
You have to select all the columns and then remove duplicates
I could not delete duplicates by selecting all the columns, but I deleted duplicates by selecting ID and date. Is this OK?
Hi,
You have to select all columns > right click and then select Remove Duplicates.
Although it did so, "Remove Duplicates." did not appear in the right click menu somehow.
I really do not know why. It worked absolutely fine for me.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |