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
goncalogeraldes's avatar
goncalogeraldes
Icon for Super User rankSuper User
5 years ago

 

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

    Thanks for your time , I Tried this calculation but getting error

    • goncalogeraldes's avatar
      goncalogeraldes
      Icon for Super User rankSuper User
      5 years ago
      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