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.
Hello everyone,
So since there is not a way to get a userinput box I am reverting to creating a table of numbers and having the user select via a slicer (they need to select their salary) and I have not been able to find a quick way to generate a table with numbers (similar to how we generate one for creating a date table). Can anyone help? So again I am just looking for a table like the one below.
TABLE
10,000
10,001
10,002
10,003
10,004
.....
1,000,000
Solved! Go to Solution.
Hi @moizsherwani,
Try a blank query in the Query Editor and paste this in to the advanced editor
let Source = List.Generate(()=>10000, each _ < 1000000, each _ + 1), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in #"Converted to Table"
Did you try pasting this into the Advanced Editor?
let Source = List.Generate(()=>10000, each _ < 1000000, each _ + 1), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in #"Converted to Table"
I don't recommend creating a DAX calculated table for this, but if you wanted to for fun you could use this:
NumberTable = VAR MinNumber = 10000 VAR MaxNumber = 1000000 RETURN SELECTCOLUMNS ( CALENDAR ( MinNumber, MaxNumber ), "Number", INT ( [Date] ) )
I don't recommend creating a DAX calculated table for this, but if you wanted to for fun you could use this:
NumberTable = VAR MinNumber = 10000 VAR MaxNumber = 1000000 RETURN SELECTCOLUMNS ( CALENDAR ( MinNumber, MaxNumber ), "Number", INT ( [Date] ) )
The only way I have figured out so far is to do a Power Query -> New Query -> {10000...1000000}
PowerBI Desktop
Did you try pasting this into the Advanced Editor?
let Source = List.Generate(()=>10000, each _ < 1000000, each _ + 1), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in #"Converted to Table"
Yes, your solution works perfectly, I am more a DAX fan so was wondering if there was a way to do this in Dax, otherwise your solution is the "BALL"
Try this for something a bit different in DAX
New Table = SELECTCOLUMNS(CALENDAR(DATE(1927,5,18),DATE(4637,11,26)),"n",int([Date]))
Hi @moizsherwani,
Try a blank query in the Query Editor and paste this in to the advanced editor
let Source = List.Generate(()=>10000, each _ < 1000000, each _ + 1), #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in #"Converted to Table"
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 |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |