Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Diference between rows with out all days

Hi everybody, first sorry for my english.


I have an excel file upload from PwBI, making a table like this (Colum A, B and C )

In Column C, I have the 3 type of stock per date. In black "15486" I have the stock at closing previus month, so for all days in April, I need to calculate the number in yellow. That is, the 15486 + accumulate value in column E (sum of production per day) less the stock

In meassure DailySales I have the accumulative sales (for ex, 7344 = 15486 + (1550+1650) - 11342) 

So I think, If I make the same meassure "DailySales Previus Day" with PreviusDay(date) function, I can subtract both and that work fine por working days, except non-working days... 

Another Idea was to crear a new table based on this, completing the days in blank and the value must be  the same as the last working day .


I need all your help, I've been stuck many days with this.




Super User
Super User

Hi @JosePareja 

can you provide a sample file?

Sorry but No, because it is confidential info of the company. But Ask me what u need to understand

Frequent Visitor

This is what im getting




Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors