How do I get the value(quantity) of the 1st day of the month

[KGPBI]

Hi all,

I want to make a measure / calculated column that gives me the value of the stock at the beginning at the month.
Even if there are no posts in that month, he must give a value.

Example: 
1-05-2020 : 245
1-06-2020: 245
1-07-2020: 245
1-08-2020: 214
1-09-2020: 214
1-10-2020: 214
1-11-2020: 223

Postingdate	Mutation	Itemnumber	Quantity
03-04-20	Positive Adjmt.	GD000349	73
03-04-20	Positive Adjmt.	GD000349	172
05-04-20	Negative Adjmt.	GD000349	-73
05-04-20	Positive Adjmt.	GD000349	172
05-04-20	Negative Adjmt.	GD000349	-172
05-04-20	Negative Adjmt.	GD000349	-172
05-04-20	Positive Adjmt.	GD000349	172
05-04-20	Positive Adjmt.	GD000349	73
24-07-20	Sale	GD000349	-20
31-07-20	Negative Adjmt.	GD000349	-11
05-11-20	Positive Adjmt.	GD000349	9

[Greg_Deckler · Accepted solution]

@KGPBI Right, and I am assuming that output is being generated from the second table posted. So are you just adding up the previous entries prior to the first of each month? That's basically

SUMX(FILTER('Table','Table'[Postingdate] < MAX('Table2'[Date]),'Table'[Quantity])

You would need a table with your first days of the month (Table2) and put that in a visual with your measure.

[KGPBI]

Thanks a lot @Greg_Deckler 

[Greg_Deckler]

@KGPBI I'm not quite following. From the example data provided, what is the expected output?

[KGPBI]

Hi @Greg_Deckler 

Thanks for answering my question.
What you see is part of the item ledger entry. I'm trying to get the stock quantity from the beginning of each month.

This is my output i want to see:
1-05-2020 : 245
1-06-2020: 245
1-07-2020: 245
1-08-2020: 214
1-09-2020: 214
1-10-2020: 214
1-11-2020: 223