last 30 days Calander

Question

hii.. team we have a case where we want to show last 30 days orders and only last 30 days orders should be shown in table and it should be dyanmic ,so we wanted to create a new calander which will have last 30 days and data should filter values from max date avalible and not todays date

arul · Answer

manishsalanke&nbsp;,
Try something similar to this calculated table,
Calendar Table = CALENDAR(
    MAX(financials[Date])-29,MAX(financials[Date]))

manishsalanke · Answer

thank you arul for your response . as per ur shared measure i have added it and it is showing dates correctly but when i add any mesure with count in a table with this date is only filters first n last date shering image for better understanding

samarth_18 · Answer

manishsalanke&nbsp;You need to use that code in calculate table instead of measure. Since you mentioned in the question where you need a new calender table with last 30 days.

manishsalanke · Answer

used it in calculated table only&nbsp;

samarth_18 · Answer

manishsalanke&nbsp;Do you have data for other dates as well? This table connected with table column which you are using to take the count?

Forum Discussion

last 30 days Calander

8 Replies

Related content

Network Days calculation with Calander and holidays

Day to Day average

Data Days | Data Days Your Way

Data Days | Create

Data Days | Full Schedule 2026