Numbers dont populated when comparing a count of a day with same day last week

[rishabjain237]

Hi community,
I am calculating count of leads per day and comparing them with same day last week. I have wrote the following formula for this.

Same Day Last Week = CALCULATE('MeasuresTable'[TotalLeads],(DATEADD('Master append'[Created_On(IST)].[Date],-7,DAY)))
MeasuresTable[TotalLeads] is CALCULATE(COUNT('Master append'[ID])
My issue is the extra 03-09-2023 to 09-09-2023 cells populating in TotalLeads column and The cells which are not populating in same day last week column as well.
Please suggest on how to solve this issue.

[rishabjain237 · Accepted solution]

Hey guys, I have found the solution to this. The date column which I was using was a hierarchy and type was date/time. I created a new date column by using format('Master append[Created_on(IST), "DD-MM-YYYY") and used this column instead of the old one. I have also Disabled Hierarchy in this new column.
Thanks!