Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey Guys.
I have a measure that is created like 'YEAR(MAX('FC ACC'[Period]))' this.
This measure has the name AcutalDateYear.
Now I want to create another measuer called ActualValue like this:
And this one is not working. It Sums up all the values which have the month 12, not filtering for the year. What am I doing wrong. If I write down the the year as an value like with the month, It works fine, but with the variable it is not working. I hope you can help me!
BR,
Solved! Go to Solution.
Hi loijoc08,
According to your description, my understanding is that you want to filter the data of the year of max data and month is 12.
In this scenario, we need to write a variable to calculate the year then filter these data, we can use the following DAX query:
Measure = var AcutalDateYear = YEAR(MAX('FC ACC'[Period])) return CALCULATE(SUM('FC ACC'[INVENTORY VALUE]),FILTER('FC ACC','FC ACC'[Period].[Year] = AcutalDateYear && MONTH('FC ACC'[Period]) = 12))
The result will like below:
Best Regards,
Teige
Hi loijoc08,
According to your description, my understanding is that you want to filter the data of the year of max data and month is 12.
In this scenario, we need to write a variable to calculate the year then filter these data, we can use the following DAX query:
Measure = var AcutalDateYear = YEAR(MAX('FC ACC'[Period])) return CALCULATE(SUM('FC ACC'[INVENTORY VALUE]),FILTER('FC ACC','FC ACC'[Period].[Year] = AcutalDateYear && MONTH('FC ACC'[Period]) = 12))
The result will like below:
Best Regards,
Teige
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |