How to multiply visitors by month to seasonality

[Kid_Koala]

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. 

[v-yulgu-msft]

Hi @Kid_Koala,

Suppose the source tables look like:

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])
)

Best regards,
Yuliana Gu

[fhill · Accepted solution]

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

[Kid_Koala]

It works! Thanks a lot, Fhill!