Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello
I need to create a table that contains the numbers 0 to n based on the number of months I have in my tables
I can use
= List.Numbers(0, 20)
to create my list
,but I want the number of rows to be dependent on a minimum and maximum dates in another table. So, for example. If the minumum date in a column is 1/1/2022, and the maximum date in a different column is 1/7/2022, that's 7 months so I want 7 rows showing the numbers 0 to 6.
Is there a way to do this? I've tried using parameters to get the min and max date, but that doesn't seem to work.
Many thanks.
Solved! Go to Solution.
I think I have worked it out using = List.Numbers(0,List.Max(claims[ClosedDevMo])+1)
I think I have worked it out using = List.Numbers(0,List.Max(claims[ClosedDevMo])+1)
Actually, change that slightly, forget about dates. I have a column in my containing the month number, I just need to create a table that goes from 0 to the max of that column value.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |