Forum Discussion

zolta_k's avatar
zolta_k
Regular Visitor
3 years ago
Solved

Summarize - how keep null value

I have data: Data of sales, Product number and Sales Quantity. There are days when there is no sale. For example: Date No Quantity 01.04.2023 123 6 03.04.2023 123 9 05.04.2023 123...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi zolta_k 

    you need to have a dimDate table connected to the main table then the table dax would be

    Table2 =
    ADDCOLUMNS (
    CROSSJOIN ( VALUES ( 'Date'[Date] ), VALUES ( Table1[No] ) ),
    "Sales 3 days", [Sum of last 3 days]
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi zolta_k 

you need to have a dimDate table connected to the main table then the table dax would be

Table2 =
ADDCOLUMNS (
CROSSJOIN ( VALUES ( 'Date'[Date] ), VALUES ( Table1[No] ) ),
"Sales 3 days", [Sum of last 3 days]
)