Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to 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 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 I'm not quite following. From the example data provided, what is the expected output?
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |