Previous month sales and MTD Last Year sales not working

[amybirc77]

Hi All,

In my data model I have created a Date Table. I imported my FACT Table from SSAS. My fact has a "charge_create_Date" heirarchy. I joined both the tables on date. But when I go ahead and create the following measures I am getting the wrong values 

.Please advice where I am doing wrong.

LM Charges = 
CALCULATE(
    SUM('Transactions'[Set 01 Charge Amount]),
    PREVIOUSMONTH('Date'[Date])
)

Charges MTD LY = 
CALCULATE (
    TOTALMTD ( SUM ('Transactions'[Set 01 Charge Amount] ), 'Date'[Date]),
    SAMEPERIODLASTYEAR ( 'Date'[Date])
)

[v-binbinyu-msft]

Hi @amybirc77 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[parry2k]

@amybirc77 check my videos on time intelligence and see if it helps

Explore SAMEPERIODLASTYEAR & PARALLELPERIOD Time Intelligence functions? Are they same? - Part 5 - Y...

Learn how to compare MTD sales as of date with same number of days in previous months - Part 6 - You...

Learn how to compare MTD sales as of date with same number of days last year - Part 7 - YouTube

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[amybirc77]

@parry2k thanks but that did not work for me. The numbers are still wrong.