year month column is coming wrong

[Kumarcy]

Hi ,

I have a date table and have monthid like 1,2,3...760 and i have month number from 1 to 12 and year column and also have Yearmonth column but when i use yearmonth column in a slicer for inbetween dates then if a user want select 201801 to 201903 the yearmonth is show 201801 to 201899 then it is showing 201901, 201902, 201903. 

Please help me.

THanks,

[Icey]

Hi @Kumarcy ,

Why does "201899" appear? If the column is created based on "Year" and "Month" column, the values, "201813" to "201899", shouldn't appear. 

Best Regards,

Icey

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

[amitchandak]

@Kumarcy , You will not be able to use Range with YYYYMM as a number. As this will be treated like a Number and give all values.

You can suggest an idea for that: https://ideas.powerbi.com/ideas/