Tableau to Power BI function

[Anonymous]

Hi Team,

Please help me in converting below formula from Tableau to PowerBI

IF avg(INT([Fiscper])) <avg( INT([Current Fiscper]) )

THEN sum([Act Inv])

ELSE RUNNING_SUM(SUM([Inventory National]))

END

[nvprasad]

Hi Raks,

For calculating running total based on date you need to create calander table separately and create relationship. 

The final measure looks like below.

IF ( avg(INT([Fiscper])) <avg( INT([Current Fiscper]) ),

sum([Act Inv]),

CALCULATE(SUM([Inventory National]), Filter(all(Table[Date]),Table[date] <= Max(Table[date]))

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

[Anonymous]

@nvprasad ,

I dont have any date table or any relationship