convert the annual sales forecast into the monthly sales forecast which added the start and end time

[Eiji77]

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?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Eiji77]

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?

[Ashish_Mathur]

Hi,

In your original screenshot, there are 2 date columns - Start and End.

[Eiji77]

Sorry!

I did not notice the custom column.

Thank you!

[Ashish_Mathur]

You are welcome.

[Eiji77]

@Ashish_Mathur

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?

[Ashish_Mathur]

Hi,

You have to select all the columns and then remove duplicates

[Eiji77]

I could not delete duplicates by selecting all the columns, but I deleted duplicates by selecting ID and date. Is this OK?

[Ashish_Mathur]

Hi,

You have to select all columns > right click and then select Remove Duplicates.

[Eiji77]

Although it did so, "Remove Duplicates." did not appear in the right click menu somehow.

[Ashish_Mathur]

I really do not know why.  It worked absolutely fine for me.