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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Monthly View from Weekly Data

Hi Everyone,

 

I've got stuck with a problem in converting from weekly data view to monthly.

 

I have a file that when on excel will work due to cell reference possibilities but not sure how to manage this on PowerBI.

 

The Formula weekly would be

([Stock for this week]/(([Sales for this week]+[Sales for Week+1])/2))*7

I created this by this measure in PowerBI

Week Calc. DOI = sum(Data[Stock])/
(sum(Data[Deliveries])+CALCULATE(sum(Data[Deliveries]),filter(all(Data[Week #]),Data[Week #]=(SELECTEDVALUE(Data[Week #])+1)))/2)*7
 
The Formula for the Monthly view is similar but would be
([Starting Stock for Month]/(([Total Sales for this Month]+[Total Sales for Month+1])/2))*30
 
The Issue I run into with this formula is that I only need the Stock from the 1st Week of the month, not the sum of all stock as its always weekly starting stock which adds onto each other. The total Sales for this Month and Month + 1 can be a sum of thie first row and the next row.
 
Can anyone help and give me advice on how to tackle this?
 
EDIT - Find the Data and PBIX file here
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.