topic DAX Create a measure that reacts with date range in DAX Commands and Tips

DAX Create a measure that reacts with date range

gabereal — Tue, 21 Mar 2023 00:29:50 GMT

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:

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.

Thanks in advance.

amitchandak — Tue, 21 Mar 2023 01:50:29 GMT

gabereal , Refer if one of the two approaches can help

Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

gabereal — Tue, 21 Mar 2023 17:47:27 GMT

amitchandak Ended up using the second example to implement the desired result.