MTD Expression

[prma7799]

Anyone can tell me that is below code is right for  MTD expression

SUM({$<FinancialYear=, Quarter=,FiscalYear={$(=max(FiscalYear))}

,[PostingDate]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[PostingDate]))"}

>}Target )

Thanks

[prma7799]

Hi sunindia‌ , gwassenaar‌ , All

MTD expression is ok but my Target table is not link properly...

Please help me on this I stuck on this from long time and unable to understand how to do...

Thanks

[sunny_talwar]

How do you think your target table should have been linked? I guess without seeing a sample, it would be difficult to say what is wrong. Can you share a sample?

[prma7799]

sunindia‌

Please find the attached ....

[Gysbert_Wassenaar]

Your Targets table contains only 1 Div_Code value and it's a different value then you have in your fact table. They should be the same if you want to be able to use the Country and Target value for anything.

[prma7799]

I have multiple(38) div code in target and all div code present in GL entry table I just debugged that file with 1 line that y its showing 1 div code...

Can you please give me solution for how can i link target table with entire data model

[Gysbert_Wassenaar]

I don't understand what you want. Your Targets table is linked to the entire model. What do you expect?

[prma7799]

Means I want to proper linking for  target table .

If my target table is properly link then y month wise targets is not showing properly.

my expected output is if i select month APR then it will show me 933859.595959596 this value for div code 2180 and country united kingdom but unfortunately its showing different values .

please see my excel file ....