Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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👍
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |