Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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

 

Anonymous
Not applicable

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

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

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

Anonymous
Not applicable

Need Help Urgent

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.