Forum Discussion
Dax Measure does not give previous values
Hello WhaleWatcher222 ,
Here’s how you can modify your formula to ensure that March 2024 is included correctly in your YTD calculations
YTD Actuals =
CALCULATE(TOTALYTD(
[Total Actuals],'Date'[Date],
ALL('Date'), -- Ensures the entire date range is evaluated
"31/3" -- This sets the fiscal year-end at March 31st),
'Date'[MonthYearSort] <= SELECTEDVALUE(_MonthYearTable[_MonthYearSort]))Filters in Model: Double-check if any other filters are being applied that might restrict March 2024 from being considered.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Hello WhaleWatcher222 ,
Here’s how you can modify your formula to ensure that March 2024 is included correctly in your YTD calculations
YTD Actuals =
CALCULATE(TOTALYTD(
[Total Actuals],'Date'[Date],
ALL('Date'), -- Ensures the entire date range is evaluated
"31/3" -- This sets the fiscal year-end at March 31st),
'Date'[MonthYearSort] <= SELECTEDVALUE(_MonthYearTable[_MonthYearSort]))
Filters in Model: Double-check if any other filters are being applied that might restrict March 2024 from being considered.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
H Thanks for the reply back i have changed the measuere to
YTD Actuals = CALCULATE(TOTALYTD([Total Actuals],'Date'[Date],ALL('Date'), "31/3"),'Date'[_MonthYearSort] <= SELECTEDVALUE(_MonthYearTable[_MonthYearSort]))the only filter in at page level is = IsCurrentFiscalYR = TRue is selected - i need the measure to work with this applied...
