Forum Discussion
Dax issue
Help required Trying more than 2 days Working on calculating year month wise MTD - month to date PMTD - previous month to date I have Date master and sales fact Working fine year , month draged...
Hi TechInayam ,
Please try this DAX:
Fiscal MTD =
VAR CurrentFiscalMonthStart = CALCULATE(MIN('Date'[FiscalStartDate]), 'Date'[FiscalYearMonthNo] = MAX('Date'[FiscalYearMonthNo]))
VAR Result = CALCULATE([Sales], 'Date'[Date] >= CurrentFiscalMonthStart, 'Date'[Date] <= TODAY())
RETURN Result
Fiscal PMTD =
VAR CurrentFiscalMonthStart = CALCULATE(MIN('Date'[FiscalStartDate]), 'Date'[FiscalYearMonthNo] = MAX('Date'[FiscalYearMonthNo]))
VAR PreviousFiscalMonthStart = EDATE(CurrentFiscalMonthStart, -1)
VAR PreviousFiscalMonthEnd = EOMONTH(PreviousFiscalMonthStart, 0)
VAR Result = CALCULATE([Sales], 'Date'[Date] >= PreviousFiscalMonthStart, 'Date'[Date] <= PreviousFiscalMonthEnd)
RETURN ResultIf not, can you provide a sample data or pbix file after removing the privacy data?
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.