Forum Discussion

Wahid777's avatar
Wahid777
Frequent Visitor
5 years ago
Solved

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], PRE...
General Comment
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    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's avatar
Wahid777
Frequent Visitor
5 years ago

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.