https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtraction-of-Oil-between-two-difference-dates/m-p/3206554#M116791 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="496414" data-lia-user-login="Aysen" class="lia-mention lia-mention-user">Aysen</a>&nbsp;</P><P>could you elaborate the business logic behind?</P> Wed, 26 Apr 2023 06:43:17 GMT FreemanZ 2023-04-26T06:43:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtraction-of-Oil-between-two-difference-dates/m-p/3205720#M116750 <P>Hi all, I need the dax for this issue, please help.</P><P>I need to have the subtraction of oil between two dates. For example,</P><P>Oil on January 1&nbsp; &nbsp; &nbsp; 12</P><P>Oil on January&nbsp; 2&nbsp; &nbsp; &nbsp; 5</P><P>Oil on January 3&nbsp; &nbsp; &nbsp; &nbsp;0</P><P>Oil on January 4&nbsp; &nbsp; &nbsp; 11</P><P>What is the diffrence between last day (January 4) and first day (January 1) =</P><P>(12+5+0+11) - 12 = 16</P> Tue, 25 Apr 2023 19:26:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtraction-of-Oil-between-two-difference-dates/m-p/3205720#M116750 Aysen 2023-04-25T19:26:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtraction-of-Oil-between-two-difference-dates/m-p/3206554#M116791 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="496414" data-lia-user-login="Aysen" class="lia-mention lia-mention-user">Aysen</a>&nbsp;</P><P>could you elaborate the business logic behind?</P> Wed, 26 Apr 2023 06:43:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Subtraction-of-Oil-between-two-difference-dates/m-p/3206554#M116791 FreemanZ 2023-04-26T06:43:17Z