Forum Discussion
Dax Measure does not give previous values
Hi Experts
My FY Runs from 31/3 to 1/4 each year when i select mar 24 i am not gettin my YTD data for Mar 24, but all dates after MAr 24 the formula is working
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
2 Replies
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...
