Forum Discussion
Solved
PREVIOUSMONTH
Hello! Attempt to calculate the sales of the previous month using this function: SP= CALCULATE ( SUM ( Table1 [number ] ) ; previousMonth (Table 2 [DATA ] ) ) However, the function does not ret...
Finally you can use your measure:
SP= CALCULATE ( SUM ( Table1 [number ] ) ; previousMonth (CalendarTable [DATE ] ) )
Thank you for answering!
i have a data table and a data fact, how ever no relationship was detected!
Hi, can you post a screenshot with tables and relationship?.
Hi Estefania89 you need a date Table with each day like a calendar.
To create a calendar table you can use:
Create a new Table (From Modeling)
CalendarTable=Calendar("01/01/2015";31/12/2016") you can change the dates according to your tables.
Next, create a relationship between date columns on your tables and Calendar Table.
Finally you can use your measure:
SP= CALCULATE ( SUM ( Table1 [number ] ) ; previousMonth (CalendarTable [DATE ] ) )