user033690 Member

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`)…
    in Max Case Statement Comment by user033690 January 2021
  • 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…
    in Year filter on YOY comparison Comment by user033690 January 2021
  • Thank you for the response Jay. 
    in Excel reporting with macros upload at appendix Comment by user033690 January 2021
  • thank you Mark. didn't even know that was there. thanks for the quick response. 
    in reporting table last 60 days Comment by user033690 December 2020
  • 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…
    in Sum of Distinct Count Variance Comment by user033690 October 2020
Default Avatar