How do we convert this Qlikview expression into power bi dax

[Anonymous]

Sum(aggr(rangesum( above( sum( [WeeklyChartData.% Actual]), 0,4)), WeeklyChartData.WeeklyChartDataKey))

[eliasayyy]

and if i may ask , why are you integrating from qlikview to powerbi?

[eliasayyy]

converting this to a DAX expression for Power BI involves a different approach since DAX doesn't work exactly like QlikView
create a calculated column or a measure that identifies the 4-week rolling sum for each row in your table.

FourWeekRollingSum = 
VAR CurrentWeek = MAX('WeeklyChartData'[WeeklyChartDataKey])
RETURN 
SUMX(
    FILTER(
        ALL('WeeklyChartData'),
        'WeeklyChartData'[WeeklyChartDataKey] <= CurrentWeek && 'WeeklyChartData'[WeeklyChartDataKey] > CurrentWeek - 4
    ),
    'WeeklyChartData[% Actual]'
)

[Anonymous]

Actually its not worked because of WeeklyChartDataKey is having Text datatype so, when I am running this measure it gives error for text and value comparison.

do u have any idea on this.