topic Re: Dax Measure to show CurrentYear vs PreviousYear in DAX Commands and Tips

Dax Measure to show CurrentYear vs PreviousYear

kmax — Mon, 11 Sep 2023 09:29:04 GMT

Hi,
I have a slicer with years (2020,2021,2022,2023)
I have a measure that shows average resolution time as below.

Avg Resolution Time (Year) = AVERAGE(Issues[Resolution Time (Days)])
I am creating a new year that shows the same data for the previous year with reference to current selected year.
But it is not working. In the visual it shows one single line. The first measure showing data correctly for alll the months of the selected year. But previous working measure is not working.
I have tried the following.
Avg Resolution Time (Previous Year by Month) =
VAR SelectedYear = MAX(Issues[Created].[Year])
VAR PreviousYear = SelectedYear - 1
RETURN
AVERAGEX(
FILTER(ALL(Issues), YEAR(Issues[Created]) = PreviousYear),
Issues[Resolution Time (Days)]
)

Avg Resolution Time (Previous Year) =
VAR SelectedYear = MAX(Issues[Created].[Year])
RETURN
CALCULATE(
AVERAGE(Issues[Resolution Time (Days)]),
FILTER(ALL(Issues), YEAR(Issues[Created]) = SelectedYear - 1)
)

Re: Dax Measure to show CurrentYear vs PreviousYear

DataNinja777 — Mon, 11 Sep 2023 11:21:24 GMT

Hi kmax,

What about simply like below?

Re: Dax Measure to show CurrentYear vs PreviousYear

kmax — Mon, 11 Sep 2023 10:52:10 GMT

It shows an error "Parameter is not the correct type"

Re: Dax Measure to show CurrentYear vs PreviousYear

DataNinja777 — Mon, 11 Sep 2023 11:22:22 GMT

Sorry about it. I fixed the syntax error. Please let me know if it works now.

Re: Dax Measure to show CurrentYear vs PreviousYear

kmax — Thu, 14 Sep 2023 10:09:45 GMT

Sorry for late reply. I am still getting an error when using the measure and Date column in to bar chart.

Re: Dax Measure to show CurrentYear vs PreviousYear

DataNinja777 — Thu, 14 Sep 2023 10:45:41 GMT

Hi kmax

How was your Calendar table created? Did you use the dax function "calendar" to create it? The error message says that your date table contains duplicates, which should not be the case if you could establish a relationship with your fact table.