https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006956#M101787 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="352527" data-lia-user-login="rohazi" class="lia-mention lia-mention-user">rohazi</a>&nbsp;</P><P>try to add a column like this:</P><LI-CODE lang="python">Diff2 = VAR _time = [Time] VAR _date = [Date] VAR _table = FILTER(TableName, TableName[Date] = _date) VAR _maxtime = MINX( FILTER( _table, TableName[Time] &gt; _time ), TableName[Time] ) VAR _totalpre= MAXX( FILTER( _table, TableName[Time] =_maxtime ), TableName[total] ) RETURN [Total] - _totalpre</LI-CODE><P>&nbsp;</P><P>it worked like this:</P><P><img /></P> Sat, 07 Jan 2023 14:13:37 GMT FreemanZ 2023-01-07T14:13:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006926#M101772 <P>please help how to get diff value for hour by hour.&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sat, 07 Jan 2023 13:12:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006926#M101772 rohazi 2023-01-07T13:12:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006934#M101776 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="352527" data-lia-user-login="rohazi" class="lia-mention lia-mention-user">rohazi</a>&nbsp;</P><P>58277 - 69706?</P> Sat, 07 Jan 2023 13:26:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006934#M101776 FreemanZ 2023-01-07T13:26:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006936#M101778 <P>60706 - 58277</P> Sat, 07 Jan 2023 13:28:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006936#M101778 rohazi 2023-01-07T13:28:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006937#M101779 <P>69706 -58277</P> Sat, 07 Jan 2023 13:29:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006937#M101779 rohazi 2023-01-07T13:29:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006946#M101783 <P>yes</P> Sat, 07 Jan 2023 14:00:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006946#M101783 rohazi 2023-01-07T14:00:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006956#M101787 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="352527" data-lia-user-login="rohazi" class="lia-mention lia-mention-user">rohazi</a>&nbsp;</P><P>try to add a column like this:</P><LI-CODE lang="python">Diff2 = VAR _time = [Time] VAR _date = [Date] VAR _table = FILTER(TableName, TableName[Date] = _date) VAR _maxtime = MINX( FILTER( _table, TableName[Time] &gt; _time ), TableName[Time] ) VAR _totalpre= MAXX( FILTER( _table, TableName[Time] =_maxtime ), TableName[total] ) RETURN [Total] - _totalpre</LI-CODE><P>&nbsp;</P><P>it worked like this:</P><P><img /></P> Sat, 07 Jan 2023 14:13:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3006956#M101787 FreemanZ 2023-01-07T14:13:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3007161#M101806 <P>tq&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="460868" data-lia-user-login="FreemanZ" class="lia-mention lia-mention-user">FreemanZ</a>&nbsp; . it's working ..thanks for your help.</P> Sun, 08 Jan 2023 00:06:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-different-value-between-hour/m-p/3007161#M101806 rohazi 2023-01-08T00:06:48Z