https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Compare-Date-Hierarchy-value-with-regular-datetime/m-p/3026681#M156568 <P>In a Measure, doing a straight comparison between a <EM>datetime or date</EM> and a <EM>Date Hierarchy</EM> results in an error:</P><P>&nbsp;</P><P>"A single value for column '<STRONG>Created ON</STRONG>' in table '<STRONG>Table</STRONG>' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."</P><P>&nbsp;</P><P><STRONG>Created On</STRONG> is a Hierarchy.&nbsp;</P><P>&nbsp;</P><P>How do you compare the date value of a Date hierarchy to a date time or just date value in DAX?</P> Tue, 17 Jan 2023 18:01:39 GMT Anonymous 2023-01-17T18:01:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Compare-Date-Hierarchy-value-with-regular-datetime/m-p/3026681#M156568 <P>In a Measure, doing a straight comparison between a <EM>datetime or date</EM> and a <EM>Date Hierarchy</EM> results in an error:</P><P>&nbsp;</P><P>"A single value for column '<STRONG>Created ON</STRONG>' in table '<STRONG>Table</STRONG>' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."</P><P>&nbsp;</P><P><STRONG>Created On</STRONG> is a Hierarchy.&nbsp;</P><P>&nbsp;</P><P>How do you compare the date value of a Date hierarchy to a date time or just date value in DAX?</P> Tue, 17 Jan 2023 18:01:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Compare-Date-Hierarchy-value-with-regular-datetime/m-p/3026681#M156568 Anonymous 2023-01-17T18:01:39Z