Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
@Prima_ , Create a new column; format will not do in this case
month Year = format([Date], "mmm YYYY")
Thanks Rico Zhou, but, that's not what I want. I tried creating a new column as suggested by amitchandak, but, it worked only after changing the format as shown below. Thanke amitchandak.
Hi @Prima_ ,
Your issue should caused by the custom format of your [Date] column. Format "MMM YYYY" will cause your date value return month short name + year like "Jan 2022'.
So whether your value is 2022/01/01 or 2022/01/02, they will return "Jan 2022".
If you want to avoid duplicates as above, please add day in your format. Format like "DD MMM YYYY".
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Prima_ , Create a new column; format will not do in this case
month Year = format([Date], "mmm YYYY")
Thanks Rico Zhou, but, that's not what I want. I tried creating a new column as suggested by amitchandak, but, it worked only after changing the format as shown below. Thanke amitchandak.