One to many relationship with date table is not working as expected

[amaleranda]

Hi Gurus, 

I have a one to many relationship with a date(one) and Transaction(many) table. But strangly it seem to be not working. see below tabel both date should be the same where it returns diffrent days. data type of date column in the transaction tabel is date.

any clue what is happening. I am uisng June 2020 of PowerBI desktop. I am out of ideas please help.

[amaleranda]

I think I found the issue, but I do not know how to reslove it.

issue is whne I drag the below measure to the table. I dont thnk this Actual YTD measure calculating it wrong.

Actual YTD =

VAR FYEnd = "30/06"

RETURN

CALCULATE(

[Amount],

DATESYTD('Date'[Date],"30/6")

)

definition of Actual measure is as below, which works fine

Amount = CALCULATE(SUM(FINANCE_DETAILS[Amount]))

[V-lianl-msft]

Hi @amaleranda ,

Could you paste the sample data you mentioned? So that we can understand your scenario better.

It is better to share sample pbix after mask any sensitive data.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.