Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone.
I'm trying to create a dynamic title that shows the quantity bought from a certain selected supplier in one ore more years, i.e.:
The problem is that it doesn't show me any selected year, even in the case I select only one single year.
This is the measure I wrote:
Can you help me? Thanks!
Solved! Go to Solution.
Hi @mtrevisiol ,
Based on your description, I created a test file, which runs well with the same measure.
Please check the relationship between the date table and other tables.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@mtrevisiol , change concatenateX like
concatenateX(values(Calendar[Date].[Anno]), calculate(max(Calendar[Date].[Anno])))
My advice would be to create a year column and use that in place of [Date].year