Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm working on a problem which seems to be quite difficult to solve to me. Hopefully anyone in the community will be able to provide a solution?
The following data is available:
I would like the table to be transformed to this to be able to easily put it on a timeline with data from other sources.
2 things are happening here:
First: Every item gets a new line in the new table with the valid prices on that particular day (Start Date till End Date), till the end of the timeline (31/12/2050 for all items)
Secondly: If a price (A, B or C) is not filled in, the price of the previous period should be filled in.
Can this be done in Power BI?
Thank you in advance for all the help!
I
Solved! Go to Solution.
@Ivan_C , I have distributed data between dates in this file. for a similar problem see if that can help
or refer blog https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
Thank you amitchandak for this information. I will look into this and give it a go. All the best!
Thank you amitchandak for this information. I will look into this and give it a go. All the best!
@Ivan_C , I have distributed data between dates in this file. for a similar problem see if that can help
or refer blog https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...
User | Count |
---|---|
94 | |
86 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |