Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Proud to give back to the community!
Thank You!
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
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
Proud to give back to the community!
Thank You!
It works! Thanks a lot, Fhill!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |