Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
neo64
Regular Visitor

Problem with dax and previous month calculation

‎08-30-2017 02:51 AM

 

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

Labels:
Message 1 of 3
879 Views
0
1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎08-30-2017 07:36 PM

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

Message 2 of 3
1,132 Views
2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎08-30-2017 07:36 PM

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.
Message 2 of 3
1,133 Views
neo64
Regular Visitor
In response to v-yulgu-msft

‎08-30-2017 11:27 PM

Thank you, work´s perfect

Message 3 of 3
849 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All