last 30 days Calander

[manishsalanke]

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]

@manishsalanke ,

Try something similar to this calculated table,

Calendar Table = CALENDAR(
    MAX(financials[Date])-29,MAX(financials[Date]))

[manishsalanke]

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 

[Arul]

@manishsalanke ,

Can you explain your ask bit more in detail?

[Samarth_18]

@manishsalanke 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]

used it in calculated table only

[Samarth_18]

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

[manishsalanke]

It has dates but it is order date so date is mentioned only when the order is there means one month can have one order also

[Samarth_18]

@manishsalanke I think thats is why you are seeing in this way. Try to add anyother column like product or something and check.