Previous month comparison

Question

Hi Folks,&nbsp;&nbsp;I am looking for solution to compare previous to current month and show indicator arrow up or down in PBI.&nbsp;&nbsp;I have date in column, below is the snapshot which i am looking for a solution.&nbsp; Thanks in advance.&nbsp;&nbsp;&nbsp;

amitchandak · Accepted Answer

Shruthi96 , One you can use icon formatting. Second, you can use icon measure and color measure. Color measure will used in conditional formatting using field value option 
&nbsp;
&nbsp;
measures
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))last month = CALCULATE(SUM(Sales[Sales Amount]),previousmonth('Date'[Date]))
this month = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
&nbsp;
&nbsp;
/////Arrow Arrow = var _change =[This month]-[Last Month]returnSWITCH (TRUE(),_change &gt; 0, UNICHAR(9650),_change = 0, UNICHAR(9654),_change &lt; 0, UNICHAR(9660))
/////Arrow ColorArrow color = var _change =[This month]-[Last Month]returnSWITCH (TRUE(),_change &gt; 0, "green",_change = 0, "blue",_change &lt; 0, "red")
&nbsp;
&nbsp;
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692https://exceleratorbi.com.au/dax-unichar-function-power-bi/

Forum Discussion

Related content

Comparison- current month vs previous month

Current month vs previous month comparison in table

Previous Month Measures

Current Month , Previous Month and Before Previous Month

Month by month comparison