Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Try something similar to this calculated table,
Calendar Table = CALENDAR(
MAX(financials[Date])-29,MAX(financials[Date]))
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
Can you explain your ask bit more in detail?
@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.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
used it in calculated table only
@manishsalanke Do you have data for other dates as well? This table connected with table column which you are using to take the count?
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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
@manishsalanke I think thats is why you are seeing in this way. Try to add anyother column like product or something and check.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |