YTD VS LYTD as of Today

[shri0025]

I have been struggling on what it is I am missing to compare last year sales data to this year sales data as of today.

when i am puting Measure on data card  LYTD show whole month i need Show data as of today now  and same issue  on MTD Data card Show Please hellp me .

 Result show as beloow LYTD = 71.54 as data card  and LY MTD SHow   0.14 as on 1 may 2022 as per my data

Please help me 

FY	Day	Month Year	Total Sales
FY 21-22	1	21-Apr	0.22
FY 21-22	2	21-Apr	0.72
FY 21-22	3	21-Apr	0.48
FY 21-22	4	21-Apr	0.08
FY 21-22	5	21-Apr	1.40
FY 21-22	6	21-Apr	2.80
FY 21-22	7	21-Apr	2.26
FY 21-22	8	21-Apr	2.34
FY 21-22	9	21-Apr	2.22
FY 21-22	10	21-Apr	1.50
FY 21-22	11	21-Apr	0.28
FY 21-22	12	21-Apr	1.10
FY 21-22	13	21-Apr	3.18
FY 21-22	14	21-Apr	2.84
FY 21-22	15	21-Apr	1.80
FY 21-22	16	21-Apr	4.44
FY 21-22	17	21-Apr	5.32
FY 21-22	18	21-Apr	0.22
FY 21-22	19	21-Apr	2.60
FY 21-22	20	21-Apr	2.02
FY 21-22	21	21-Apr	2.04
FY 21-22	22	21-Apr	2.58
FY 21-22	23	21-Apr	1.72
FY 21-22	24	21-Apr	2.90
FY 21-22	25	21-Apr	0.64
FY 21-22	26	21-Apr	2.04
FY 21-22	27	21-Apr	2.88
FY 21-22	28	21-Apr	5.32
FY 21-22	29	21-Apr	8.08
FY 21-22	30	21-Apr	5.36
FY 21-22	1	21-May	0.14
FY 22-23	1	22-Apr	0.74
FY 22-23	2	22-Apr	0.14
FY 22-23	3	22-Apr	0.00
FY 22-23	4	22-Apr	0.28
FY 22-23	5	22-Apr	0.70
FY 22-23	6	22-Apr	1.00
FY 22-23	7	22-Apr	0.98
FY 22-23	8	22-Apr	1.10
FY 22-23	9	22-Apr	2.14
FY 22-23	10	22-Apr	0.00
FY 22-23	11	22-Apr	1.64
FY 22-23	12	22-Apr	2.02
FY 22-23	13	22-Apr	3.18
FY 22-23	14	22-Apr	3.06
FY 22-23	15	22-Apr	4.84
FY 22-23	16	22-Apr	3.36
FY 22-23	17	22-Apr	0.46
FY 22-23	18	22-Apr	3.58
FY 22-23	19	22-Apr	5.48
FY 22-23	20	22-Apr	5.60
FY 22-23	21	22-Apr	3.48
FY 22-23	22	22-Apr	3.30
FY 22-23	23	22-Apr	2.46
FY 22-23	24	22-Apr	1.02
FY 22-23	25	22-Apr	3.48
FY 22-23	26	22-Apr	3.34
FY 22-23	27	22-Apr	4.56
FY 22-23	28	22-Apr	6.14
FY 22-23	29	22-Apr	8.46
FY 22-23	30	22-Apr	13.12
FY 22-23	1	22-May	0.06

[shri0025]

Have been searching the forum for a while but without finding any answers to my questions:

1. I have created a MTD measure but this won't show any values if I don't have a date filter (= this month). 

    TotalMTD = TOTALMTD(SUM(PostedSalesInvoices[Amount]);dCalendar[Date])

2. I also want a LY MTD but this shows me the sales for the whole month previous year, not MTD.

   Totalt LMTD = CALCULATE ( [TotalMTD]; SAMEPERIODLASTYEAR( dCalendar[Date] ) )

[shri0025]

Hi please help  

i need MTD sales  LY mtd sales  Date wise  If  20 jun 22 MTD sales and LY mtd 20 Jun 

[shri0025]

Hi Not working 

[v-yangliu-msft]

Hi  @shri0025 ,

Here are the steps you can follow：

1. Create calculated table.

Date =
CALENDAR(DATE(2021,1,1),DATE(2022,12,31))

2. Create calculated column.

Year = VALUE("20"&""&LEFT('Table'[Month Year],2))

Month =
var _mon=RIGHT('Table'[Month Year],3)
return
CALCULATE(MAX('Date'[Month_number]),FILTER(ALL('Date'),'Date'[Month]=_mon))

Date_true =
DATE('Table'[Year],'Table'[Month],'Table'[Day])

3. Create measure.

LYTD =
CALCULATE(SUM('Table'[Total Sales]),FILTER(ALL('Table'),'Table'[Date_true]>=DATE(YEAR(TODAY())-1,1,1)&&'Table'[Date_true]<=EOMONTH(TODAY(),-12)))

LY MTD =
CALCULATE(MAX('Table'[Total Sales]),FILTER(ALL('Table'),'Table'[Date_true]>=DATE(YEAR(TODAY())-1,MONTH(TODAY())-1,1)&&'Table'[Date_true]<=EOMONTH(TODAY(),-13)))

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly