Master Calendar Range Problem

[#1]

Dear All,

I have data with start and end date. I have connected the master calender to my fact table over start date. If one of the mesguliyet_kodu doesn't end on the started month I have a problem. For example when I select "II" mesguliyet_kodu, it started on 18th April (Nisan) but ended on 5th May (Mayis). So the total day between end and start date is 17. But I want to see it 12 on April and 5 on May.

How can I succeed it?

Hope to hear you soon.

Best Regards,

Asim Akin

[llauses243 · Accepted solution]

Hi,

My offer is by script, pls see image & zip atached

Good luck, Luis

[#3]

Dear Luis

Thanks for your solution. However AY field makes loop on the table structure because I have anothter table that I didn't sent you in my example. Please see the attached error messages. Is it possible to fix it?

[llauses243]

Hi,

This is my schema (see image attached), no match with your schema, then is for me other case

Send me your .qvw thanks, Luis.