Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Eiji77
Helper II
Helper II

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

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?

 

無題.png

無題.png

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

11 REPLIES 11
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Sorry!

I did not notice the custom column.

Thank you!

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@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?

Hi,

 

You have to select all the columns and then remove duplicates


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.