Adding X number of days in Calendar Dimension Table based on the last date in Order Table

[HammoD]

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?

[Vijay_A_Verma · Accepted solution]

Use this

= Table.SelectRows(#"Inserted Start of Month", each [Date] <= Date.AddDays(List.Max(Orders_Table[Date]), 10)))

[HammoD]

Thanks a lot. Issue is solved👍