Forum Discussion
Helper IIDrill down is not working
Community SupportHi rajanimaddala ,
Sorry for that, but we cannot reproduce your issue after applying your formula on our sample table.
Does your chart similar with the sample we have shared? What is the relationship between your ‘fact’ table and ‘calendar’ table, “Many to one” or “one to one”? Does the calendar table only contain Continuous time value?
Could you please reproduce this issue on the sample we have shared?
BTW, pbix as attached.
Best regards,
Helper IIHi v-lid-msft,
I have exactly same relationship as in your pbix
Please see attached 2 screenshots
1. Week in Fact table which is correct
2. Week in calendar ta ble which is wrong
Week calculation is as below
CASE
WHEN DATEPART(DAY, [transaction Date]) BETWEEN 1 AND 7 THEN 'Week 1'
WHEN DATEPART(DAY, [transaction Date]) BETWEEN 8 AND 14 THEN 'Week 2'
WHEN DATEPART(DAY, [transaction Date]) BETWEEN 15 AND 21 THEN 'Week 3'
WHEN DATEPART(DAY, [transaction Date]) BETWEEN 22 AND 28 THEN 'Week 4'
ELSE 'Week 5'
END
Why is not working with Week in calendar tableWeek in Fact TableWeek in Calendar Table