cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaiKumar
Frequent Visitor

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 Net Bookings (1)])))
               THEN WINDOW_AVG(SUM([Total Net Bookings (1)]), -4, 0)
               END

7 REPLIES 7
goncalogeraldes
Super User
Super User

 

Test = 
var total_bookings_sum = SUM(Total Net Bookings[Your_Column_Name]) 
var thisweek =
    MAX ( Your_Table_Name[Fiscal Week Name] )
var last5weeks =
    TOPN ( 5, 
    FILTER ( 
       ALL ( Your_Table_Name[Fiscal Week Name] ), Your_Table_Name[Fiscal Week Name] <= thisweek 
          ), 
     Your_Table_Name[Fiscal Week Name], 
     DESC )
return
IF(
  NOT( ISBLANK( total_bookings_sum )),
  CALCULATE ( AVERAGE ( total_bookings_sum), last5weeks )
)

 

Thanks for your time , I Tried this calculation but getting errorSet.png

Test = 
var thisweek =
    MAX ( Your_Table_Name[Fiscal Week Name] )
var last5weeks =
    TOPN ( 5, 
    FILTER ( 
       ALL ( Your_Table_Name[Fiscal Week Name] ), Your_Table_Name[Fiscal Week Name] <= thisweek 
          ), 
     Your_Table_Name[Fiscal Week Name], 
     DESC )
return
IF(
  NOT( ISBLANK( total_bookings_sum )),
  CALCULATE ( AVERAGE ( Total Net Bookings[Your_Column_Name]), last5weeks )
)

 

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

goncalogeraldes
Super User
Super User

The average function offsets based on dates?

amitchandak
Super User
Super User

@SaiKumar , 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.



Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Learn Power BI P&L Statement || Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s ||
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!!! How to get Quick Help !!
Resources | Master Power BI !! Expertise Power BI !! Power BI For Tableau User !!

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

                                                END
                                                Screenshot 2021-08-12 181052.png

Need Help Urgent

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.