Forum Discussion
Anonymous
4 years agoNot applicable
Adding missing date rows and filling in Quantity
Hi, I have a table INVENTORY which has Inv_Date and the respective Quantity, as follows; Inv_Date Quantity 01.01.2021 10 02.01.2021 10 05.01.2021 15 07.01.2021 ...
AlexisOlson
Super User
4 years agoIt sounds like you're trying to define a measure or calculated column instead of a new table.
As a separate note, you may want to filter the calendar part if you only want one day per month. I.e.
FILTER (
CALENDAR (
MIN ( INVENTORY[Inv_Date] ),
MAX ( INVENTORY[Inv_Date] )
),
DAY ( [Date] ) = 1
)
Anonymous
4 years agoNot applicable
I created a table with the original query (Modeling > New table).