Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I have two tables, a date table and an table with date ranges.
DateTable:
DATE Table |
01/01/2023 |
01/02/2023 |
01/03/2023 |
01/04/2023 |
Item Date Range Table:
ITEM | FROMDATE | TODATE |
ITEM-A | 01/01/2023 | 01/02/2023 |
ITEM-B | 01/01/2023 | 01/04/2023 |
ITEM-A | 01/01/2023 | 01/04/2023 |
I would like to create a measure, that I can use along with the DATE Table, to get a count of items that could produce the following results.
DATE Table | Measure Val for Item-A |
01/01/2023 | 2 |
01/02/2023 | 2 |
01/03/2023 | 1 |
01/04/2023 | 1 |
Thanks in advance.
Solved! Go to Solution.
@gabereal , Refer if one of the two approaches can help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
@amitchandak Ended up using the second example to implement the desired result.
@gabereal , Refer if one of the two approaches can help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |