DAX formula Day to Day for Year -1
Hi, I need help to get the right formula for my dashboard As you can see on my screenshot, I want to see the MTD from last year. I managed to do it but the total in my table is not the right one. The total is the total of the month, while I would like the total of the month until today's date minus 1 year To obtain the measurement Invoiced Sum YEAR-1 I used the following formula : Invoiced Sum YEAR-1 = CALCULATE([Invoiced_Sum],SAMEPERIODLASTYEAR('Calendar'[Date])) To obtain the measurement Invoiced MTD YEAR -1 I used the following formula : Invoiced MTD YEAR -1 = IF([Invoiced Sum YEAR-1] <> BLANK(), CALCULATE('Main'[Invoiced Sum YEAR-1],DATESMTD('Calendar'[Date])),BLANK()) To obtain the measurement Invoiced MTD YEAR -1 per DAY I used the following formula : Invoiced MTD YEAR -1 per DAY = IF( NOT ISBLANK([Invoiced_Sum]), CALCULATE('Main'[Invoiced Sum YEAR-1],DATESMTD('Calendar'[Date])),BLANK()) Thanks a lot to those who can help me Paul
