How to compare all-time monthly values and output percentage changes ?
Hello Community, I am experiencing difficulty creating a DAX Command that compares my monthly averages and percentage changes. I need to see all-time average rather than the average for the month. I will include the information below. I need to display the % change in a table with the following columns: Product Identification, (All time - 2022-9), (All time - 2022-10), and % change. I do not own the live dataset. Any help would be greatly appreciated. I will provide images below. Thank you! Best,Show MoM % and YoY % at the end of a Matrix Visual
Hi there, I have a Matrix Visual which shows a result for each row for each month. I would like to show the MoM% and YoY % change based on the last date in table only (as pictured below) I can get MoM/YoY% to work, but cannot figure out how to only apply this to the last date in the table. Can anyone help with this?
Calculate average sales for calendar month
Here we have found a simple way to find out the average sales for the calender month. Calender Qunatity Sum = Var startMonth = Date(Year(Today()),1,1) Var EndMonth = EOMONTH ( TODAY (),-1) Return Calculate(SUMX(Table Name,Qunatiy Column), Filter(All(Table Name), 'Date Table >= startMonth && 'Date Table<= EndMonth ) ) Calender Quantity Average = Var Month = MONTH(TODAY()) - 1 return divide(Calender Qunatity Sum,Month,0)
