Forum Discussion

yasbos's avatar
yasbos
Icon for Resolver II rankResolver II
6 months ago
Solved

Date relationship issues

Hi. I have this weird issue with dates. I have an accounts table that is related to the Account[Date Opened] *-->1  _date[Date] field in the _date table. The relationship is inactive. However, I acti...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    Could you please try this: 

    Traded Accts D7 =
CALCULATE(
    DISTINCTCOUNT(account[Account Number]),
    USERELATIONSHIP(_date[Date], account[Date Opened]),
    CROSSFILTER(account[Account Number], Assets[Account Number], NONE),
    FILTER(
        account,
        NOT ISBLANK(account[First Trade Date]) &&
        account[First Trade Date] <= account[Date Opened] + 7
    )
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 months ago

Hi,

Share the download link of the PBI file.

yasbos's avatar
yasbos
Icon for Resolver II rankResolver II
6 months ago

Second update: it seems that when I changed the crossfilter between the Account and the Assets tables from both to single that that fixed the problem too without having to deactivate this relationship.