Forum Discussion

yasbos's avatar
yasbos
Icon for Resolver II rankResolver II
7 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
    7 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
7 months ago

Hi,

Share the download link of the PBI file.

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

Hi. This is a direct-query complex power bi report. It's not always possible to share the pbi files here. I was hoping that someone here had encountered a similar problem. I'm going to try to create a separate file with some sample extracts from the same tables and see if i can do that. Thanks.