March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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
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 error
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
The average function offsets based on dates?
@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.
Average 5Wk Net Bookings = IF NOT(ISNULL( SUM([Total Net Bookings (1)])))
THEN WINDOW_AVG(SUM([Total Net Bookings (1)]), -4, 0)
END
Need Help Urgent
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
97 | |
85 | |
69 | |
61 |
User | Count |
---|---|
138 | |
120 | |
109 | |
99 | |
97 |