https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2524240#M70525 <P>Hi community!</P><P>I have a table that shows me several records per day for each article:</P><TABLE border="1"><TBODY><TR><TD>Article</TD><TD>DateTime</TD><TD>Value</TD></TR><TR><TD>A</TD><TD>01.01.2022 01:00:00</TD><TD>5</TD></TR><TR><TD>B</TD><TD>01.01.2022 01:50:00</TD><TD>8</TD></TR><TR><TD>C</TD><TD>01.01.2022 08:00:00</TD><TD>6</TD></TR><TR><TD>B</TD><TD>01.01.2022 01:00:00</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Each article has for each dax the same amount of rows with the same datetime.</P><P>Now I would like to sum the value for each article always for the first DateTime per Day.</P><P>&nbsp;</P><P>&nbsp;</P><P>How would you do that using DAX?</P> Wed, 18 May 2022 19:26:06 GMT joshua1990 2022-05-18T19:26:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2524240#M70525 <P>Hi community!</P><P>I have a table that shows me several records per day for each article:</P><TABLE border="1"><TBODY><TR><TD>Article</TD><TD>DateTime</TD><TD>Value</TD></TR><TR><TD>A</TD><TD>01.01.2022 01:00:00</TD><TD>5</TD></TR><TR><TD>B</TD><TD>01.01.2022 01:50:00</TD><TD>8</TD></TR><TR><TD>C</TD><TD>01.01.2022 08:00:00</TD><TD>6</TD></TR><TR><TD>B</TD><TD>01.01.2022 01:00:00</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Each article has for each dax the same amount of rows with the same datetime.</P><P>Now I would like to sum the value for each article always for the first DateTime per Day.</P><P>&nbsp;</P><P>&nbsp;</P><P>How would you do that using DAX?</P> Wed, 18 May 2022 19:26:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2524240#M70525 joshua1990 2022-05-18T19:26:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2524330#M70535 <P>Hi:</P><P>I will attach a solution. You will see I added just a Data column to your table and the visual on page one is set to not summarize.</P><P><A title="First Value" href="https://drive.google.com/file/d/1ydN4Y-C4RIwgvft_KBQgI84UzIXLWaOE/view?usp=sharing" target="_self">https://drive.google.com/file/d/1ydN4Y-C4RIwgvft_KBQgI84UzIXLWaOE/view?usp=sharing</A>&nbsp;</P><P>&nbsp;</P><P><img /><img /></P><P>&nbsp;</P> Wed, 18 May 2022 20:05:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2524330#M70535 Whitewater100 2022-05-18T20:05:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2532897#M71094 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="92006" data-lia-user-login="joshua1990" class="lia-mention lia-mention-user">joshua1990</a>&nbsp;,</P> <P>&nbsp;</P> <P>Having trouble to follow.</P> <P>What is the expected result?</P> <P>A table like below:</P> <TABLE border="1"> <TBODY> <TR> <TD>Article</TD> <TD>DateTime</TD> <TD>Value</TD> </TR> <TR> <TD>A</TD> <TD>01.01.2022 01:00:00</TD> <TD>5</TD> </TR> <TR> <TD>C</TD> <TD>01.01.2022 08:00:00</TD> <TD>6</TD> </TR> <TR> <TD>B</TD> <TD>01.01.2022 01:00:00</TD> <TD>2</TD> </TR> </TBODY> </TABLE> <P>Or a single value which is 5+6+2 = 13?</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Jay</P> Mon, 23 May 2022 09:58:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filter-on-first-DateTime-per-Day/m-p/2532897#M71094 Anonymous 2022-05-23T09:58:04Z