DAX Support - Complex formula PowerBI
Budget: $10 – $15 USD
I want to combine the average results of week 8/1, 8/8 and 8/15 to get my assumptions for week 9/5 using DAX in PowerBI
I'm using past results to calculate assumptions two weeks ahead.
That means I need to combine results of week 8/15, 8/22 and 8/29 to get my estimates for week 9/19
If my skill doesn't have data, the estimate will be 30%
I'm using past results to calculate assumptions two weeks ahead.
That means I need to combine results of week 8/15, 8/22 and 8/29 to get my estimates for week 9/19
If my skill doesn't have data, the estimate will be 30%