need help with a formula creating a new table by summarize for each day last 30 days values

[cristianj]

Hello ,

I am trying to write something like this

Sumar 30 zile = summarize(

    buy_phone_details

    ,buy_phone_details[Data comanda S]

    ,buy_phone_details[model]

    ,"Nr telefoane",calculate(count(buy_phone_details[id]),filter(buy_phone_details),buy_phone_details[Data comanda S]<=[Data comanda S]&&buy_phone_details[Data comanda S]>[Data comanda S]+30)

)

but i seems i can;t get it right. Thank you for yur help

[negi007]

@cristianj  you can create a summary table like below which will show date for last 30 days. You can use your date column and modify the code accordingly.

summary_Sales = SUMMARIZE(FILTER(Orders,Orders[Ship Date]>=TODAY()-30),Orders[Product Category],Orders[Product Sub-Category],"Sales",SUM(Orders[Sales]))

[cristianj]

Thank you for your answer, i don't need only for last 30 days, i need to calculate for each day the value for last 30 days, starting from each day in the table.