cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kid_Koala Frequent Visitor
Frequent Visitor

How to multiply visitors by month to seasonality

Hi guys, need your help with adjusting a seasonality weight to visitors chart.

I've got two tables: the first one with the number of visitors to my web site by date (dd/mm/yy). The second one contains seasonality weight by month.

I need to multiply seasonality data to my visitors data mounth by month, but have no idea how to do this. I'm sure it's an easy move, but I really stuck with that. 

Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
fhill Established Member
Established Member

Re: How to multiply visitors by month to seasonality

Like many things in PowerBi there are several ways to acomplish this; here's one suggestion...

 

I created two custom columns in your Visitors table for Adj_Lookup (Lookup the Adjustment Value based on 'Start of Month' matching' and Adj.Visitors where I just multiple the adjustment by original visitors count.

 

Adj_Lookup = LOOKUPVALUE(tblAdj[Adj.],tblAdj[Month],STARTOFMONTH(tblVisitors[Date]))

Adj.Visitors = tblVisitors[Visitors] * tblVisitors[Adj_Lookup]

 

Then just create a summary table of Visitors and Adj.Visitors.

FOrrest

 

Capture.PNGCapture2.PNG

3 REPLIES 3
fhill Established Member
Established Member

Re: How to multiply visitors by month to seasonality

Like many things in PowerBi there are several ways to acomplish this; here's one suggestion...

 

I created two custom columns in your Visitors table for Adj_Lookup (Lookup the Adjustment Value based on 'Start of Month' matching' and Adj.Visitors where I just multiple the adjustment by original visitors count.

 

Adj_Lookup = LOOKUPVALUE(tblAdj[Adj.],tblAdj[Month],STARTOFMONTH(tblVisitors[Date]))

Adj.Visitors = tblVisitors[Visitors] * tblVisitors[Adj_Lookup]

 

Then just create a summary table of Visitors and Adj.Visitors.

FOrrest

 

Capture.PNGCapture2.PNG

Community Support Team
Community Support Team

Re: How to multiply visitors by month to seasonality

Hi @Kid_Koala,

 

Suppose the source tables look like:

1.PNG2.PNG

 

Please create a calculated table using below DAX formula:

summarize visitor table =
ADDCOLUMNS (
    SUMMARIZE (
        'Visitor table',
        'Visitor table'[Date].[MonthNo],
        "visitor number", SUM ( 'Visitor table'[visitors] )
    ),
    "multiply result", [visitor number] * LOOKUPVALUE('Seasonality table'[Weight],'Seasonality table'[Month],[Date].[MonthNo])
)

3.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.
Highlighted
Kid_Koala Frequent Visitor
Frequent Visitor

Re: How to multiply visitors by month to seasonality

It works! Thanks a lot, Fhill!Smiley Very Happy