Forum Discussion

Helper V

5 years ago

Solved

Help with Target Dates Please

Hello, I was hoping someone could help me please. I have 2 fields in the same query called Target Date and Actual Date. Then I have another field in the same query called Product. I need to be a...

amitchandak
5 years ago
Pricey79 , Here I am assuming you add a date table and join that with Actual Date and filter week from it.

for week vs week or week calendar refer

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

Anonymous

Not applicable

5 years ago

It sounds like a common multiple date fields range analyses requirement, you can take a look at the following blog 'start date', 'end date' part if helps:

Before You Post, Read This

In addition, you can also consider creating a calculated table to expand the records in the ranges then you can simply do summarize/aggerate with these fields.

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,

Xiaoxin Sheng