Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Tableau to power Bi Migration

I am currently working on migrating Tableau Reports to Power BI. I am currently facing problems in converting the Tableau Calculation . Needed help in this.      Test =  IF NOT(ISNULL( SUM([Total N...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , WINDOW_AVG is table level calculation not supported in power, So we need push rolling based on the group by of visual. That also needs some sequence

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Average 5Wk Net Bookings = IF NOT(ISNULL( SUM([Total Net Bookings (1)])))
                                                    THEN WINDOW_AVG(SUM([Total Net Bookings (1)]), -4, 0)

                                                    END
                                                   

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Need Help Urgent