topic Re: Difference between two rows with some filters in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Difference-between-two-rows-with-some-filters/m-p/3240581#M119218 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="562133" data-lia-user-login="Caseiluva" class="lia-mention lia-mention-user">Caseiluva</a> , I think offset can do a better job.</P> <P><A href="https://medium.com/microsoft-power-bi/power-bi-offset-function-84177cc2cafd" target="_blank">https://medium.com/microsoft-power-bi/power-bi-offset-function-84177cc2cafd</A></P> <P>Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: <A href="https://youtu.be/5YMlkDNGr0U" target="_blank">https://youtu.be/5YMlkDNGr0U</A></P> Wed, 17 May 2023 15:27:44 GMT amitchandak 2023-05-17T15:27:44Z Difference between two rows with some filters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Difference-between-two-rows-with-some-filters/m-p/3240384#M119202 <P>Hello, im gonna show first an image just to help you undesrtand what im trying to do:</P><P><img /></P><P> </P><P>I want to calculate the difference between rows that have the same number in colum "Nºtrade" and the difference is between the row with "Cierre" - "Apertura".</P><P>&nbsp;</P><P>I hope you undesrtand what im trying to achieve.</P><P>Its just a measure to cacluate the Profit&amp;Loss of a list of trades.</P> Wed, 17 May 2023 14:06:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Difference-between-two-rows-with-some-filters/m-p/3240384#M119202 Caseiluva 2023-05-17T14:06:36Z Re: Difference between two rows with some filters https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Difference-between-two-rows-with-some-filters/m-p/3240581#M119218 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="562133" data-lia-user-login="Caseiluva" class="lia-mention lia-mention-user">Caseiluva</a> , I think offset can do a better job.</P> <P><A href="https://medium.com/microsoft-power-bi/power-bi-offset-function-84177cc2cafd" target="_blank">https://medium.com/microsoft-power-bi/power-bi-offset-function-84177cc2cafd</A></P> <P>Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: <A href="https://youtu.be/5YMlkDNGr0U" target="_blank">https://youtu.be/5YMlkDNGr0U</A></P> Wed, 17 May 2023 15:27:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Difference-between-two-rows-with-some-filters/m-p/3240581#M119218 amitchandak 2023-05-17T15:27:44Z