Previous Month Line Items to be displayed

[Anonymous]

Hi,

I am trying to display the projects that started the previous month based on the current month as filter. So When I choose March 2020, it should show Feb 2020 - Project 1, 2 & 3 along with the Feb 2020 Revenue.  

Kindly help me with the appropriate DAX expression. Thanks! 

[kentyler · Accepted solution]

You can probably use the function SUMMARIZECOLUMNS to create a table that had only the columns of the previous month.

You could also add a calculated column to your data that displayed the following month for each row's date. You would not display that column in your table, but you would use it to create the slicer. Then when you picked a value in the slicer you would get all the rows in the table that had that month as the previous month. That is, picking jan in the slicer would display all the rows with feb dates, because feb is the "following" month for jan.

[amitchandak]

@Anonymous 

You can get with time intelligence. examples

MTD Sales = CALCULATE(Max(Date[Month Name]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(Max(Date[Month Name]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

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-bi
https://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#M184


Appreciate your Kudos.