Forum Discussion

remi113's avatar
remi113
New Member
3 years ago

Previous Month showing same value as Current Month

Hello everyone, I am trying to make a graphic (cards) comparing current month sales to previous month sales.  I am using a month-year sales table and a calendar table.  For some reason, I can not get...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Please show the complete Data Model. 

With what do you have the bidirectional relationship with your Month-Year Sales Table? 

And talking of Month-Year Sales Table, what is the reasoning behind creating this table? I think you have created an additional table which was never required at first place, and hence made your Data Model complex. 

 

As for the DAX, I would suggest using PREVIOUSMONTH to get the values for your last month, 

 

PREVIOUSMONTH = CALCULATE(SUM('month-year sales'[monthly sales]), PREVIOUSMONTH('Calendar Table'[Date]))
remi113's avatar
remi113
New Member
3 years ago

Hi, I will attach an image of my data model.  I honestly am not sure why I created a separate table, I just knew I needed this data so created it in Excel and imported it, I am new to PowerBI and modeling, this is my first project.  When I use PREVIOUSMONTH, the DAX accepts it, but returns (Blank) for every month in PREVIOUSMONTH.  Here is my data model.