Difference between value fo the same column but filter by month

Question

Dears,&nbsp;&nbsp;the left column is the previous month, and on right its the last month (who whas finished);&nbsp;As you can see the is a count of people for each side, i would like the know the difference between these two value and put it in the center (where is it "-14").Notice: the "count of people" is the same column used in twice, that's the same column in the power query editor.&nbsp;Thank you so much to you all.&nbsp;Nico

amitchandak · Accepted Answer

NnIc0 , You can use time intelligence with Date table and do it
example
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 MTD (complete) Sales =  CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
&nbsp;
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer : https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions https://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184Appreciate your Kudos.

Forum Discussion

Difference between value fo the same column but filter by month

2 Replies

Related content

1. How to add two different calculated columns of two different table

Different schema into different destination

How to add two different calculated columns of two different table

Different Groupby Column Names in Summarize

Need column level difference