Hello,
I am struggling to write a Dax formula that will solve my problem. I work for a company that has many brands all added to our site at different times. I would like to write a formula that will give me the average daily Revenue YTD for a brand in 2016 and 2015. If my slicer has a range selected of Jan-Sep I would like to have the avg daily revenue of a brand between Jan and Sep 2016 and Jan Sep 2015. If the brand was not on the site in Jan of 2015 I would like to say since the brand was live (first order date) til Sep of 2015 the Daily revenue was x.
Can someone please help me with this.
I am struggling to write a Dax formula that will solve my problem. I work for a company that has many brands all added to our site at different times. I would like to write a formula that will give me the average daily Revenue YTD for a brand in 2016 and 2015. If my slicer has a range selected of Jan-Sep I would like to have the avg daily revenue of a brand between Jan and Sep 2016 and Jan Sep 2015. If the brand was not on the site in Jan of 2015 I would like to say since the brand was live (first order date) til Sep of 2015 the Daily revenue was x.
Can someone please help me with this.