Table columns format

[Utilisateur_pb]

Hi everyone,

I write this message, to ask for suggestions concerning my demand.

I want to create a table like this :

But i couldn't do it with what powerBI offers: I used the matrix and i couldn't do it what i want is just the first measure from the first column (with year 2023) below and all the measures under the second column with year 2024

Don't hesitate to suggest me solutions to show my table as i want .

Best regards.

[Anonymous]

Hi @Utilisateur_pb ,

Could you please provide more details? Such as demo pbix file (does not contain sensitive data). That will help us understand the problem better.

Thanks for @djurecic reply.

Best regards,

Mengmeng Li

[djurecic]

Hi @Utilisateur_pb ,

 What measures have you created for years 2023 and 2024? Are you using a date table? You can create measures for a specific year using Calculate and Filter.

[Utilisateur_pb]

Hi, thank you for your response.

I created the measures that calculate the charges for the year selected and the year before and the gap between the two. The thing is it will be automated every year, i want to show the actual year and the year before, and i can't do this with measure, because its name can't be automated to change years.