cancel
Showing results for
Did you mean:
Highlighted
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
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.

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

FOrrest

3 REPLIES 3
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.

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

FOrrest

Community Support Team

## Re: How to multiply visitors by month to seasonality

Hi @Kid_Koala,

Suppose the source tables look like:

Please create a calculated table using below DAX formula:

```summarize visitor table =
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])
)```

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

## Re: How to multiply visitors by month to seasonality

It works! Thanks a lot, Fhill!