Fetching values from previous month

[Wahid777]

Hi there

I'm trying to fetch values from previous month to eventually calculate a MoM variance % but my measure returns with too many arguements error. 

I've tried CALCULATE(SUM[Signups], PREVIOUSMONTH([Month])

I have the following table

[Jihwan_Kim · Accepted solution]

Hi, @Wahid777 

Please check the below pictures.

It is better to have Dim-Date-Table in order to conveniently use the time-intelligent-DAX-function in Power BI.

And the connection between the two tables is needed.

All measures are in the sample pbix file's link down below.

https://www.dropbox.com/s/3m2d6kqk7rjn501/Wahid777.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

[Wahid777]

Thank you

I understand the sorting of the table was a mess but i was only able to get it this way from the database. You're table dimension is the perfect approach to this.

However, since I couldn't change the table, I was able to export the data to excel and used pivot table there to arrange them seperately and used another similar table to calculate the MoM variance % using the first table (transformed using pivot table) as the data source. 

[Wahid777]

PS: The Month column's data type is date/time and has data from 2020 and 2021. It is fetched from sql but I can't connect it to Power BI because the SQL Server tables has way too many binary IDs. I've grouped by the data i need in sql and copied it in excel and then loaded to power bi from the excel file.