Duplicates in slicer by month please help!

[Anonymous]

Hello,

I have a appened table based on yearly data pulled from SAP. (2020 \ 2021).

I have created a Date table which added a date hierarchy too.

in the slicer I can add Month from both the date hierarchy or "More fields".

Problem is that if i add the slicer from the date hierarchy - it shows duplicate values (i.e, January, January, Febuary, Febuary...)

and if i add the slicer from the "More fields" the "SamePeriodLastYear" function doesnot work.

Please Help 🙂

[Anonymous · Accepted solution]

I found that the duplicate values in the month slicer and the error in the sameperiodlastyear function occur when in the pivot table there are both years added, so as a workaround i seperated the years into two pivot tables.

Thanks all for the assist!

[PaulDBrown]

Did you create a relationship between the date table and your fact table?

[Anonymous]

Yes i did. 

[PaulDBrown]

Are both the date fields set as date types? (You mentioned you created the date field by: "The yearly data is actualy pulled in a yearmonth format (i.e. 202001) and in the appened query i transformed it to date by adding 01 (Yearmonth & "01"). "

Both date fields must be date types: ie 01/01/2021 and not 20210101

[Anonymous]

yes they are, after adding the "01" i changed the column to date. 

the function "sameperiodlastyear" works, but not when i add the month slicer... then i get the error. 

[PaulDBrown]

Just to check, can you provide a screenshot of the date columns?

Also, why are you creating slicers from two different "Month" fields?

[daxer-almighty]

Clean your data. The fact that you see an entry twice does not mean this is the same entry. There are invisible characters at play here. Just standardize your entries.

[Anonymous]

I checked, data is clean. 

The yearly data is actualy pulled in a yearmonth format (i.e. 202001) and in the appened query i transformed it to date by adding 01 (Yearmonth & "01"). 

then added the relationship to the date table.

I still get the error above.

any thoughts on that??? THANKS!