Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamically Generate Series/Table

I am creating a Range Penetration (RP) Calculator (where RP = (Salary - min of salary Range)/(Max of Salary Range - Min of Salary Range) )for multiple Countries in Power Bi, I am using whatif parameter to generate a series of Salaries (GENERATESERIES(20000,1000000,100). Now the problem is since I have multiple countries the GenerateSeries function is not able to give all possible Salaries to enduser to enter and calculate the RP. Is there a way to dynamically generate a series/Table based on the Min Salary Range & Max Salary of each country

Need Help
Tips and Tricks

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    Anonymous So like this? PBIX is attached below signature. This is basically Blowout! Blowout! - Microsoft Fabric Community

    Table2 = 
    VAR __Table =
        GENERATE(
            SUMMARIZE( 'Table', [Column1], "__Min", MIN('Table'[Column2]), "__Max", MAX('Table'[Column2]) ),
            GENERATESERIES( [__Min], [__Max], 1 )
        )
    VAR __Return = SELECTCOLUMNS( __Table, "Country", [Column1], "Salary", [Value] )
RETURN
    __Return