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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

New month /year columns base off date field base off accounting calender

All

I need to summarize data totals of supplier receipts for each month by our company accounting calender. So for Jan-2017 for this year, I would need to summizae total of all the receipts by the  supplier code from Jan-2-2017 to Feb-5-2017 (Week 1 to Week 5). I perfer to have a new column withthe accounting calender month /year base off the Date Received field in the attached post but have the correct claender month if the last week goes into next week, So Feb-2-2017 would show as Jan-2017 in the new column for our account calender month.

 

Sample Data

Date ReceivedOrg IdQty ReceivedSupplier CodeSupplier Name
2/21/2017 9:08CBN1111471-BELGIUM-01XPOFED
2/21/2017 9:00CBN1111471-BELGIUM-01XPOFED
12/6/2016 10:28CBN1111471-BELGIUM-01XPOFED
12/6/2016 10:25CBN1111471-BELGIUM-01XPOFED
10/27/2016 8:38CBN1111471-BELGIUM-01XPOFED

 

ACCOUNTING Calender

 

2017 ACCOUNTING CALENDER.jpg

 

 

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@Anonymous -

 

Perhaps a possible solution could be found in my blog post @ http://cjmendoza.yourweb.csuchico.edu/custom-calendar/create-a-custom-period-calendar-in-power-query/ ? I am sure there could be a way to programmatically re-assign the period names however, I could not come up with one in my attempts this morning. It must be my 'pretty day'.






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Anonymous
Not applicable

Any Thoughts?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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