Forum Discussion

Vevu's avatar
Vevu
New Member
4 years ago
Solved

How to get MAX value from GENERATESERIES function with FILTER?

Hi all,   I am new in Power BI and I have a question regarding using a variable table in a calculated column. I have a table, andI'd like to make a calculated column.  It will evaluate each row, c...
Need Help
  • Vevu's avatar
    Vevu
    4 years ago

    Oh nevermind I found out how! 
    It should be:

    calculatedcolumn = 
var _series = generateseries([mindata],[maxdata],[binsize])
var _bin = MAXX(FILTER(_series, [Value] <= [row_value]), [Value])
return
_bin

    Thank you!

Vevu's avatar
Vevu
New Member
4 years ago

Oh nevermind I found out how! 
It should be:

calculatedcolumn = 
var _series = generateseries([mindata],[maxdata],[binsize])
var _bin = MAXX(FILTER(_series, [Value] <= [row_value]), [Value])
return
_bin

Thank you!