Forum Discussion
joshua1990
Post Prodigy
Post ProdigyProject Value between to dates
I have a simple table that shows me a value per Article Article Value Date A 1000 01.01.2021 A 1050 01.02.2021 As you can see, each value gets a new value per month. Now I wou...
amitchandak
Super User
Super Userjoshua1990 , Create a date date table .
Create a new end date column
end date =
minx(filter(Table, Table[Article] = earlier(Table[Article] ) && Table[Date] >earlier(Table[Date])),Table[Date])
rename date as start date in table
then create a table
filter(Crossjoin (Table, Date), [Date] >=[Start Date] && [Date] <=[End Date])
A similar example in the attached file