Forum Discussion
year month column is coming wrong
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,
2 Replies
- amitchandak
Super User
Anonymous , 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/
- Icey
Community Support
Hi Anonymous ,
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.
