Forum Discussion
Anonymous
3 years agoNot applicable
Tableau to Power BI function
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])...
nvprasad
3 years agoSolution Sage
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
3 years agoNot applicable
nvprasad ,
I dont have any date table or any relationship