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 paramet...
Need Help
Tips and Tricks
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