Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
The following code only generates 32766 rows. Is this a restriction to the function or table, or am I doing something wrong?
Dates = GENERATE(GENERATESERIES(1;60815); VAR days = [value] Return ROW("Dates"; DATE(1880;1;days)))
Cheers
Solved! Go to Solution.
UPDATE:
The table did have more than 32766 rows, but after 32766 the date didn't change anymore. The problem looks to be the DATE() function which can't handle a 'day' value larger than 32766...?
After changing the code all was fine. The new code is:
Dates = GENERATE(GENERATESERIES(1;datediff(date(1880;1;1);now();DAY)); VAR days = [value] Return ROW("Dates"; DATE(1880;1;1)+days))
Thanks for the help!
https://docs.microsoft.com/en-us/dax/generateseries-function
@etrietsch wrote:Hi,
The following code only generates 32766 rows. Is this a restriction to the function or table, or am I doing something wrong?
Dates = GENERATE(GENERATESERIES(1;60815); VAR days = [value] Return ROW("Dates"; DATE(1880;1;days)))Cheers
@Anonymous wrote:https://docs.microsoft.com/en-us/dax/generateseries-function
I have read the documentation on this function. How is this answering the question?
UPDATE:
The table did have more than 32766 rows, but after 32766 the date didn't change anymore. The problem looks to be the DATE() function which can't handle a 'day' value larger than 32766...?
After changing the code all was fine. The new code is:
Dates = GENERATE(GENERATESERIES(1;datediff(date(1880;1;1);now();DAY)); VAR days = [value] Return ROW("Dates"; DATE(1880;1;1)+days))
Thanks for the help!
Hi @etrietsch,
What's the version you are on?
Tried your code with February version and got 60.815 rows, no issue on my version.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix I use Power BI Version: 2.66.5376.1681 64-bit (februari 2019) and Windows 10 Home (64-bit)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |