Forum Discussion

Pravi6436's avatar
Pravi6436
New Member
2 years ago

Link issue with Date Dimension table

hello all,

am facing issue in relationship with date table. i have two tables on is ledger and one is date table.

i have created link between posting date and date column in date table(marked as date table). but blank is coming. what is the issue

 

Job MTD =TOTALMTD(SUM(Job_Ledger_Entries_Excel[Line_Amount_LCY]),
                      Job_Ledger_Entries_Excel[Posting_Date],Job_Ledger_Entries_Excel[Entry_Type]="sale")
 
in this above query am getting result bcz am using the same table. if am using date table am getting blank value.

 

 

 

Need Help

3 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    2 years ago

    Check the data types of both fields used in the relationship.  They should be the same type