Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 |
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).
Hi please help
i need MTD sales LY mtd sales Date wise If 20 jun 22 MTD sales and LY mtd 20 Jun
Hi Not working
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |