Forum Discussion
MOM and QOQ Filters Calculation
Hi, I have a graph which compares Customer Name on the Y_Axis and SalesAmount on the X_Axis.They need a MOM and QOQ filters.What exactly QOQ/MOM i am referring is when i select a month in the filter...
Hi,
Thanks a lot for the reply.
When i created a derived column using below Dax,
PreviousOrders_ = CALCULATE(SUM(Sheet1[OrderAmount]),DATEADD(Sheet1[BillStartDate],-1,MONTH))
I am getting an empty with no data.May i know why?
This should be written as a measure, not a column.