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