Write a column of Date depending of a measure containing dates

[Anonymous]

Hello,

I got a measure which contains years (Sometimes there are the same year many times). For exemple I can have 2019,2019,2019,2021,2021,2021.

And I would like to create a column in a new table that gonna summarize and put only 2019 and 2021 one times.

As my years are in a measure, all I tried failed

Do you have any suggestion?

Thank you for your help

Best regards

[v-yingjl · Accepted solution]

Hi @Anonymous ,

If your year measure is calculated based on a date column, you can create a new calculated table like this directly without using the measure:

Table 2 = 
SUMMARIZE (
    ADDCOLUMNS ( ALL ( 'Table' ), "Year", YEAR ( 'Table'[Date] ) ),
    [Year]
)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you!