Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables, Date and Inventory. Inventory is a distinct look at inventory with a New date and Sold Date attached. Is there a way to take the Date from the Date Table and count how many times it shows up in the New and Sold ranges. This will give me how much was in inventory on those days.
Inventory Table
ID | New | Sold |
47883602 | 6.23.2022 | 7.01.2022 |
41622522 | 7.01.2022 | 7.01.2022 |
45181882 | 5.20.2022 | 7.02.2022 |
48105302 | 7.01.2022 | 7.03.2022 |
43855572 | 6.08.2022 | 7.05.2022 |
50316242 | 6.30.2022 | 7.05.2022 |
50301082 | 7.01.2022 | 7.05.2022 |
50396872 | 7.01.2022 | 7.05.2022 |
50137862 | 7.05.2022 | 7.05.2022 |
41236432 | 5.16.2022 | 7.06.2022 |
If I look at date 6/08 it would show 3 in inventory, 7/01/2022 would show 9 in inventory
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you, this solved a weeks worth of headaches
You are welcome.
You can try just use a simple matrix with [New] as a row, and then the count of [New] as the value. And then do the same for Sold.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |