Reply
Highlighted
Frequent Visitor
Posts: 8
Registered: ‎09-12-2017
Accepted Solution

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. 


Accepted Solutions
Established Member
Posts: 234
Registered: ‎04-20-2017

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

View solution in original post


All Replies
Established Member
Posts: 234
Registered: ‎04-20-2017

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
Posts: 5,880
Registered: ‎09-21-2016

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.
Frequent Visitor
Posts: 8
Registered: ‎09-12-2017

Re: How to multiply visitors by month to seasonality

[ Edited ]

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