user033690

About

Username
user033690
Joined
Visits
0
Last Active
Roles
Member
Badges
0

Comments

  • Hi I have a similar question. I used the suggested MAX formula to compare 2 years. I have 5 year data and need to compare them by using a filter. With below BM, it looks like it returns the right numbers for they are at the right columns: Recent Year: case when MAX(MAX(`Year`)) OVER () = `Year` then sum(`Gross Revenue`)…
  • Hi Mark, Thank you for the quick response. I am looking to be able to use a year filter in a dashboard. I do have other BM within the dashboard like % Change, share, and variance. I am hoping to have a dynamic dashboard instead of recreating the dashboard every year. User can choose 2 years i.e. 2019 & 2020 and be able to…
  • Thank you for the response Jay. 
  • thank you Mark. didn't even know that was there. thanks for the quick response. 
  • Thank you for the response Grant. I tried the BM you suggested. unfortunately it gives me a different result. Please review the table below. I am looking to get the FY20-FY19 variance both by item and as a total. I hope you can help me figuring this out. Thank you in advance. Item NumberFY20 Customer CountFY19 Customer…