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.
I would like to pass a dynamic end value to the GENERATESERIESE function.
I have an imported (not calculated table), one of its collumns contains the numbers that i would like to use as the end value in the function. The idea is this:
I tried to pass with VALUE, VALUES, SELECTEDVALUE, but I could not make them work. I'm fine with using something else than generateseries, as long as the output table looks like the one on the picture. I have to do his on the fly, Power Query is not an option.
Any ideas?
PBIX: https://drive.google.com/file/d/1B8KNjfGynVRotLn5RYKQGu9b8w2PZSvw/view?usp=sharing
Solved! Go to Solution.
Goodmorning @nonoka
Calculated tables cannot read the filter context. What are you trying to acheive is not possible.
I would suggest to create a completely new table as follows https://www.dropbox.com/t/2rv9ENz3TZdvyAXQ
Could you please show me what is in the Series.Value measure? The code does not work on my end.
Not a measure. just:
GENERATESERIES(1,100,1)
The trick is, that i'm not passing any dynamic parameter into it.
I'm just using the drill through function to get a single Title and using MAX() to get the word count of the selected title.
and from there it's easy to use the measure on the filter and sort away any number from the GENERATE series table, that is below the MAX() measure
Hi @nonoka
I believe I can help on this. Please explain what is your ultimate goal and what are the expected results?
The "Num" table will serve as a base for an other function, that will split the title sentences to words.
The "Num" table is just a list of numbers starting from 1 and ending with 100 (for example).
The problem with this is that when I visualize the table I will get the words, but also additional empty lines, because the tables length will be exactly 100 rows (the user will scroll through empty rows --> not uder friendly ). In addition, if there are more than 100 words in the title, then not all words will be shown.
My goal is to create the 'Num' table exactly as long as the amount of words in the given title.
@nonoka
How are these words seperated? By spaces or commas? Can you provide a dammy sample with what are you expecting as a final result?
All the info is in the pbix file. Thnk you.
https://drive.google.com/file/d/1B8KNjfGynVRotLn5RYKQGu9b8w2PZSvw/view?usp=sharing
Goodmorning @nonoka
Calculated tables cannot read the filter context. What are you trying to acheive is not possible.
I would suggest to create a completely new table as follows https://www.dropbox.com/t/2rv9ENz3TZdvyAXQ
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 |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |