https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-based-on-same-date-and-same-field/m-p/2903667#M94661 <P>Can you please share the dataset</P> Mon, 14 Nov 2022 12:47:21 GMT Anonymous 2022-11-14T12:47:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-based-on-same-date-and-same-field/m-p/2903633#M94657 <P><img /></P><P>Hi Im a bit new to dax and I am struggling in creating a formula.</P><P>So I need to write a mathmateical calculation which&nbsp;=+(E<STRONG>4</STRONG>+<STRONG>Mx6</STRONG>)/2*33&nbsp; for th<STRONG>e East Silo</STRONG> on the same date and time only.&nbsp;</P><P>&nbsp;</P><P>So the first one would be 07/11/2022 4:30 am calculation (4+4)/2*33</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 14 Nov 2022 12:28:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-based-on-same-date-and-same-field/m-p/2903633#M94657 Anonymous 2022-11-14T12:28:55Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-based-on-same-date-and-same-field/m-p/2903667#M94661 <P>Can you please share the dataset</P> Mon, 14 Nov 2022 12:47:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-based-on-same-date-and-same-field/m-p/2903667#M94661 Anonymous 2022-11-14T12:47:21Z