topic Power BI DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/3991387#M154886 <P>Hi</P><P>I need a DAX to calculate the variance % for etime data.</P><P>&nbsp;</P><P>I am trying to using some date related DAX but it is not helping me.</P><P>The variance I am trying to get is</P><P>(# of open tickets in previous month - # of open tickets in reporting month) / # of open tickets in previous month</P><P>&nbsp;</P><P>Start of the reporting month is 28 -Feb- 2023</P><P>sample data is below:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD>Open Requests (Reporting Month)</TD><TD>Open Request (Previous Month)</TD><TD>Variance%</TD></TR><TR><TD>Feb-23</TD><TD>10206</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Mar-23</TD><TD>10062</TD><TD>10206</TD><TD>1.41%</TD></TR><TR><TD>Apr-23</TD><TD>11336</TD><TD>10062</TD><TD>-12.66%</TD></TR><TR><TD>May-23</TD><TD>17215</TD><TD>11336</TD><TD>-51.86%</TD></TR><TR><TD>Jun-23</TD><TD>17390</TD><TD>17215</TD><TD>-1.02%</TD></TR><TR><TD>Jul-23</TD><TD>20903</TD><TD>17390</TD><TD>-20.20%</TD></TR><TR><TD>Aug-23</TD><TD>20692</TD><TD>20903</TD><TD>1.01%</TD></TR><TR><TD>Sep-23</TD><TD>23140</TD><TD>20692</TD><TD>-11.83%</TD></TR><TR><TD>Oct-23</TD><TD>24764</TD><TD>23140</TD><TD>-7.02%</TD></TR><TR><TD>Nov-23</TD><TD>23598</TD><TD>24764</TD><TD>4.71%</TD></TR><TR><TD>Dec-23</TD><TD>22180</TD><TD>23598</TD><TD>6.01%</TD></TR><TR><TD>Jan-24</TD><TD>22566</TD><TD>22180</TD><TD>-1.74%</TD></TR><TR><TD>Feb-24</TD><TD>24318</TD><TD>22566</TD><TD>-7.76%</TD></TR><TR><TD>Mar-24</TD><TD>21883</TD><TD>24318</TD><TD>10.01%</TD></TR><TR><TD>Apr-24</TD><TD>22906</TD><TD>21883</TD><TD>-4.67%</TD></TR><TR><TD>May-24</TD><TD>18542</TD><TD>22906</TD><TD>19.05%</TD></TR><TR><TD>Jun-24</TD><TD>24589</TD><TD>18542</TD><TD>-32.61%</TD></TR></TBODY></TABLE> Thu, 13 Jun 2024 14:34:17 GMT Megha2498 2024-06-13T14:34:17Z Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/3991387#M154886 <P>Hi</P><P>I need a DAX to calculate the variance % for etime data.</P><P>&nbsp;</P><P>I am trying to using some date related DAX but it is not helping me.</P><P>The variance I am trying to get is</P><P>(# of open tickets in previous month - # of open tickets in reporting month) / # of open tickets in previous month</P><P>&nbsp;</P><P>Start of the reporting month is 28 -Feb- 2023</P><P>sample data is below:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Month</TD><TD>Open Requests (Reporting Month)</TD><TD>Open Request (Previous Month)</TD><TD>Variance%</TD></TR><TR><TD>Feb-23</TD><TD>10206</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Mar-23</TD><TD>10062</TD><TD>10206</TD><TD>1.41%</TD></TR><TR><TD>Apr-23</TD><TD>11336</TD><TD>10062</TD><TD>-12.66%</TD></TR><TR><TD>May-23</TD><TD>17215</TD><TD>11336</TD><TD>-51.86%</TD></TR><TR><TD>Jun-23</TD><TD>17390</TD><TD>17215</TD><TD>-1.02%</TD></TR><TR><TD>Jul-23</TD><TD>20903</TD><TD>17390</TD><TD>-20.20%</TD></TR><TR><TD>Aug-23</TD><TD>20692</TD><TD>20903</TD><TD>1.01%</TD></TR><TR><TD>Sep-23</TD><TD>23140</TD><TD>20692</TD><TD>-11.83%</TD></TR><TR><TD>Oct-23</TD><TD>24764</TD><TD>23140</TD><TD>-7.02%</TD></TR><TR><TD>Nov-23</TD><TD>23598</TD><TD>24764</TD><TD>4.71%</TD></TR><TR><TD>Dec-23</TD><TD>22180</TD><TD>23598</TD><TD>6.01%</TD></TR><TR><TD>Jan-24</TD><TD>22566</TD><TD>22180</TD><TD>-1.74%</TD></TR><TR><TD>Feb-24</TD><TD>24318</TD><TD>22566</TD><TD>-7.76%</TD></TR><TR><TD>Mar-24</TD><TD>21883</TD><TD>24318</TD><TD>10.01%</TD></TR><TR><TD>Apr-24</TD><TD>22906</TD><TD>21883</TD><TD>-4.67%</TD></TR><TR><TD>May-24</TD><TD>18542</TD><TD>22906</TD><TD>19.05%</TD></TR><TR><TD>Jun-24</TD><TD>24589</TD><TD>18542</TD><TD>-32.61%</TD></TR></TBODY></TABLE> Thu, 13 Jun 2024 14:34:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/3991387#M154886 Megha2498 2024-06-13T14:34:17Z Re: Power BI DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/3991789#M154898 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="702110" data-lia-user-login="Megha2498" class="lia-mention lia-mention-user">Megha2498</a>,</P> <P>You can create a calculated column below and adjust the output format to percentage:</P> <P><img /></P> <P>In plain text:</P> <LI-CODE lang="markup">calc_column_solution = VAR curMonthValue = [Open Requests (Reporting Month)] VAR curMonth = [Month] VAR prevMonth = MAXX ( FILTER ( tbl_with_data, [Month] &lt; curMonth ), [Month] ) VAR prevMonthValue = MINX ( FILTER ( tbl_with_data, [Month] = prevMonth ), [Open Requests (Reporting Month)] ) RETURN DIVIDE ( prevMonthValue - curMonthValue, prevMonthValue )</LI-CODE> <P><STRONG><FONT size="2">Best Regards, </FONT></STRONG></P> <P><STRONG><FONT size="2">Alexander</FONT></STRONG></P> <P><STRONG><FONT size="2"><A href="https://youtube.com/@powerbi-vlog" target="_blank">My YouTube vlog in English</A></FONT></STRONG></P> <P><STRONG><FONT size="2"><A href="https://youtube.com/@pbi-vlog" target="_blank">My YouTube vlog in Russian</A></FONT></STRONG></P> <P>&nbsp;</P> Thu, 13 Jun 2024 20:00:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Power-BI-DAX/m-p/3991789#M154898 barritown 2024-06-13T20:00:49Z