Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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"
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |