Reference day of the week forecast

[Anonymous]

Hello,

I need help with a measure that does not apply values to all dates.

I created a ratio between item count and transactions from 4/12/2020 - 4/18/2020. Next created measure to multiply the created ratio to transactions (with values from 1/1/2020 - 12/31/2020), but the calculation only shows data 4/12/2020 - 4/18/2020. I'd like to get this ratio applied by day of the week (i.e. 4/12 Sunday * every Sunday in year 2020).

TIA, any advice is greatly appreciated,

Ryan

[Anonymous]

More info needed.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best
D