Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the below set analysis for my MTD calculation at straight table:
[Order Date]={"$(='>=' & Date(MonthStart(Max([Order Date])), 'MM/DD/YYYY') & '<=' & Date(Max([Order Date]), 'MM/DD/YYYY'))"}>}Sales)
but it gives me wrong result and in the below screenshots you can see that: Ideally it should show all the order date in the table, but it only show the last year's date in the 'Order Date' column.Also the MTD value should be start date of the Order Date's month to the corresponding Order date, but the value in MTD column is wrong here.
Also I am attaching my demo QVW for reference.
May be this
Sum({$<[Order Date]={">=$(=Date(MonthStart(Max([Order Date]))))<=$(=Max([Order Date]))"}>}[Sales])
Hello Sandip,
Please refer below link:
Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)
Regards!
Rahul