Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a rather large table of sales data. But the only 3 items coumsn i am having issue with are the below 3.
Each row is beasicly a product. We have a column for when the item was put the the sales floor. A column for when an item was sold. and a column for the quantity of items.
Now i have a Date Range Slicer already made that will show me a table (like the one below) For all items that were put out to th sales floor based on the date range selected. What i want, to created a new measure that will sum "Item sold count" if it was
Both to the floor AND sold in the date range of the slicer. Is this possible?
Date Range Selected 1/1/2020 - 1/5/2020
Date to the Floor | Date Sold | Items sold count |
1/1/2020 | 1/1/2020 | 4 |
1/2/2020 | 1/3/2020 | 3 |
1/2/2020 | 1/5/2020 | 7 |
1/3/2020 | 1/3/2020 | 1 |
1/5/2020 | 1/5/2020 | 1 |
1/5/2020 | 1/6/2020 | 2 |
1/5/2020 | 1/8/2020 | 3 |
Total | 21 |
Create a measure that returns 0 or 1 given your criteria and use it as a filter for the visualization.
So, along the lines of:
Measure =
VAR __Date = SELECTEDVALUE('Table'[Date])
RETURN
IF('Table'[Date to the Floor] = __Date && [Date Sold] = __Date,1,0)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |