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