Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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👍