Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
neo64
Regular Visitor

Problem with dax and previous month calculation

 

Hello, I have a data table similar to this:

 

DateUrlVisitsPrev month visits
01/05/2017/2050 
01/05/2017/implants1505 
01/06/2017/1900 
01/06/2017/implants2105 
01/07/2017/1560 
01/07/2017/implants1360 

 

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

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

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
)

2.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

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
)

2.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you, work´s perfect

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.