Data in date fields aggregated

[NCPowerBI]

Hi all,

I converted a date field from this format - 05/28/2023 - to this format - 05/2023 since each row has a day in the date field and I want it to aggregate on my table. It worked fine, with one flaw. It isn't aggregating the row data on my table and instead looks like the below. I just need the month and year so the table aggregates it so it's one month per row. Does anyone know the work around for this one? Thanks in advance!

[Ritaf1983 · Accepted solution]

Hi @NCPowerBI 
Recommend working with a date table that contains all needed date formats.

Please refer to my answer on the link:

https://community.fabric.microsoft.com/t5/Desktop/How-to-use-calendar-table/m-p/3178510

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly