Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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]))

END

Need Help

2 Replies

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      nvprasad ,

      I dont have any date table or any relationship