Problem with dax and previous month calculation

[neo64]

Hello, I have a data table similar to this:

Date	Url	Visits	Prev month visits
01/05/2017	/	2050
01/05/2017	/implants	1505
01/06/2017	/	1900
01/06/2017	/implants	2105
01/07/2017	/	1560
01/07/2017	/implants	1360

And I'm trying to create a calculated column with visits from the previous month by url, but I'm very new to DAX and I can´t.

Can you help me?

Thank you very much

[v-yulgu-msft · Accepted solution]

Hi @neo64,

Suppose your table is called 'Visit Table', you could try this formula:

Prev month visits =
LOOKUPVALUE (
    'Visit Table'[Visits],
    'Visit Table'[Url], 'Visit Table'[Url],
    'Visit Table'[Date].[MonthNo], 'Visit Table'[Date].[MonthNo] - 1
)

Best regards,
Yuliana Gu

[neo64]

Thank you, work´s perfect