DAX: Creating a measure to conditional format between a calendar table and data table w start/end

Question

Hello Everyone,&nbsp;Im trying to create a matrix visual that will highlight that is inbetween start and end date by title off of a calendar column.&nbsp;&nbsp;Please see below&nbsp;table1table2 date&nbsp;What I have so far -&nbsp;CF = CALCULATE (1,&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; table2,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table2[Date] &gt;= min(table1[startdate] )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; table2[Date] &lt;= max(table1[enddate] )&nbsp; &nbsp; ))&nbsp;&nbsp;Doesnt work since it populate everything to 1, it needs to be dynamic enough to go row by row&nbsp;example solution that what im trying to get to&nbsp;&nbsp;

amitchandak · Accepted Answer

K3nnysiu , refer my blogs on this topic&nbsp; 
&nbsp;
Between Dates - Dates between
Measure wayPower BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMhttps://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
Table Wayhttps://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90bhttps://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
&nbsp;

Forum Discussion

DAX: Creating a measure to conditional format between a calendar table and data table w start/end

2 Replies

Related content

EBIT Financial Bridge - Dynamic Start and End

range match of event dates within a start and end conditions

Create start date and end date from date

Creating a Measure Start date, End date, duration

Create graph by start , end date