Here you go. Below is the formula which we have used for MTD. ToDate("Warehouse"."Fact - Sales Order"."Sales Amount"."Warehouse"."Dim - Time"."Month") Please let me know on how can i create previous Month MTD and Previous Year same Month MTD

I wasnt having access to my system as I have already left for the day yesterday. So I have clearly mentioned in my last comment that I will paste formula and screenshots on monday. I have clearly mentioned that MTD formula is correct and is working as expected. Previous month Mtd and previous year same month mtd is not…

Thanks Christian. But I am sure formula is correct. Because rolling 3 months, rolling 1 month and month ago is working perfectly.I will keep you posted on monday along with screenshots which will include column formula and hierarchy.

TODATE(Measure,month level from hierarchy)

Hello christian, For MTD i have used todate and it is working fine. but for previous Month MTD and previous year same month MTD is not working as expected. Date Measure MTD PMTD PYMTD 1-Jan-2019 10 10 2-Jan-2019 20 30 . . 1-Feb-2019 40 40 10 value which was there on 1-Feb-2018 2-Feb-2019 50 90 30 value which was there on…

we would be having issues with the leap year. if we exclude that scenario how can we achieve it.

Thanks Gianni for your question. we had same question in our mind still we need to go back to customer on that part. we are thinking if our current_date is 28 Feb 2017 PMTD would be 1Jan2017 to 28 Jan2017 and PYMTD would be 01FEB2016 to 28FEB2016

Set control flag sufficient for default authenticator and restart it will work.