Forum Discussion

ashmozzart's avatar
ashmozzart
Frequent Visitor
9 years ago

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...
Need Help
ashmozzart's avatar
ashmozzart
Frequent Visitor
9 years ago

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?

 

 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi ashmozzart,

 

As most Time Intelligence Functions (DAX) require an individual and consecutive Date table to work correctly, you may need create it using CALENDAR or CALENDARAUTO Function (DAX) if you don't have yet. And create a relationship between the Date table and your fact table with the Date column.

 

Assume your Date table is called "DateTable", then the formula to create the measure should like below.

PreviousOrders_ =
CALCULATE (
    SUM ( Sheet1[OrderAmount] ),
    DATEADD ( DateTable[Date], -1, MONTH )
)

 

Regards