Forum Discussion
Fetching values from previous month
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
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.
3 Replies
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.
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.
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.
