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.
Hi,
I have two tables:
* Dynamic calendar table used as lookup table
* Order table as fact table
What I did, instead of building Calendar table for a full year, I did it as:
= Table.SelectRows(#"Inserted Start of Month", each [Date] <= List.Max(Orders_Table[Date]))
where calndar table is filtered based on the last order date recorded in (Order Table).
Now I am looking to modify the query to add 10 more days on List.Max(Orders_Table[Date]) ,how to achevie that?
Solved! Go to Solution.
Use this
= Table.SelectRows(#"Inserted Start of Month", each [Date] <= Date.AddDays(List.Max(Orders_Table[Date]), 10)))
Use this
= Table.SelectRows(#"Inserted Start of Month", each [Date] <= Date.AddDays(List.Max(Orders_Table[Date]), 10)))
Thanks a lot. Issue is solved👍
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.