Forum Discussion

Bukha's avatar
Bukha
Frequent Visitor
8 years ago
Solved

Adding rows for unrecorded days

Greetings all,       I have a table that has some data based on days of the month like the below example:   How is it possible to add the dates between the shown dates and assign th...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Bukha,

     

    Seems you'd like a new table. Try the formula below please.

    Table =
ADDCOLUMNS (
    CALENDAR ( MIN ( 'Table1'[Date] ), MAX ( 'Table1'[Date] ) ),
    "# of Porducts", IF (
        ISBLANK ( LOOKUPVALUE ( Table1[# of Products], Table1[Date], [Date] ) ),
        0,
        LOOKUPVALUE ( Table1[# of Products], Table1[Date], [Date] )
    )
)

    Adding_rows

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Bukha,

 

Seems you'd like a new table. Try the formula below please.

Table =
ADDCOLUMNS (
    CALENDAR ( MIN ( 'Table1'[Date] ), MAX ( 'Table1'[Date] ) ),
    "# of Porducts", IF (
        ISBLANK ( LOOKUPVALUE ( Table1[# of Products], Table1[Date], [Date] ) ),
        0,
        LOOKUPVALUE ( Table1[# of Products], Table1[Date], [Date] )
    )
)

Adding_rows

 

Best Regards,

Dale