Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi guys
This probably a simple question but hope you can shed some light. I have a table from web api call which has over 80,000 rows plus keeps on increasing week by week. Now, I need to an another table with the same number of rows. Currently, I use the below to create series and manually increase each week or increase one off to 90,000.
Solved! Go to Solution.
Hi @Sankzpower ,
Just add the following code refering to the first table:
Table 2 = GENERATESERIES(1, COUNTROWS('Table'))
Should work as expected.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Sankzpower ,
Just add the following code refering to the first table:
Table 2 = GENERATESERIES(1, COUNTROWS('Table'))
Should work as expected.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi I'm using version 2.105.664.0 but this makes an error which says "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value".
My DAX is this.
Measured Table = SELECTCOLUMNS(FILTER('MyTable', 'MyTable'[MyColumn] <> BLANK()),
"Column1", [Column1],
"Column2", [Column2],
"Column3", GENERATESERIES(1, COUNTROWS(FILTER('MyTable', 'MyTable'[MyColumn] <> BLANK()))))
Hi @Anonymous ,
Be aware that the calculation it was given was for a table, you are using a metric and metrics only return a single value so in this case you are trying to return a table, that is why it's giving you the scalar value error.
What is the result you want to achieve in this?is it a table?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
55 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |