MTD and LMTD comparison date wise

[ishansjain2095]

Hi All,

Facing problem in pivot chart with below

MTD Expression:

Sum ({<[Date.autoCalendar.Date]={">=$(=AddMonths(MonthStart (Today ()),0))<=$(=AddMonths(MonthEnd (Today ()),0))"}>}[Total Sales])

Comparison Expression date wise like: current date/day- Previous date/day {Run it till current Month}

Same with LMTD

LMTD Expression:

Sum ({<[Date]={">=$(=AddMonths(MonthStart (Today ()),-1))<=$(=AddMonths(MonthStart (Today ())))"}>}[Total Sales])

How to create compare date wise expression:

????

Please help!!!!!

[tommyl]

Hello,

Could you please depict what you expect in a table here? 

Cheers,

T.

[ishansjain2095]

Hi Tommyl,

I have added 'date wise' MTD in row field and 'sale property' name in column field and the above expressions for MTD/LMTD is used in measure.

So, from those I get sales name wise total sales and date wise total sales in row format like a tabular form .

What I require is to compare date wise sum of Total Sale ??? Like :

(<DD-MM-YYYY><Sum(TotalSales)>) - (<(DD-MM-YYYY)-1><Sum(TotalSales)>)

Regards,

ISJ

[ishansjain2095]

Any expression to compare sum(total Sales) DateWise like for example comparing current minus previous date.....

Or is there any function data type to compare all dates with Sum(TotalSales)...