Forum Discussion
Helper IDynamic revenue Data +4 weeks and - weeks
Hi lsuresh89
Please see the attached file with the solution, this file contains three tables:
- YourSample - the sample that was provided.
- ExpandedDays - a table that extends YourSample table to individual day between "Agreement Start Date" and "Agreement End Date" and splits Total Revenue to individual Date.
- Relative Date Dimension table that enables filtering the weeks to current, previous 4 and forthcoming 4, here is the blog about it if you are interested https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.Hi lsuresh89
To clear the error adjust the ExpandDays Function by adding +1 at the end of days step like below.
If adding +1 didn't fix the issue, then you need to check the data set if the start date is always lower or equal to end date as the error suggest this is not the case.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Helper IHi Mariusz , The only problem with using this step is that for actuals I do not want to divide the total profit by week. I have the weekly numbers with me. How can i tweak this formula and the ExpandDays function?
I have the weekly profitability numbers by produtc viz. Week 36 - $ 4567, Week 35 - $ 5657.... but I cant find a way to connect these weekly numbers with my pipleine.
