Forum Discussion

Kashinoda's avatar
Kashinoda
Advocate I
8 years ago

Using DAX operators on multiple Dates from the same Fact table?

Hi Guys,   This has been doing my head in a little.   I have a Date Dimension Table and a Fact Table with multiple Date Columns.   I wish to find an arbitary total, on the condition that DATE1 ...
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

What problem are you facing?  What result are you expecting and what do you actually get.  Share the link from where i can download your file.  Also, show the expected result there.

  • Kashinoda's avatar
    Kashinoda
    Advocate I
    8 years ago

    The problem I'm facing is both FKInvoiceDate and FKCreditDate are not date columns they're just INT stored as YYYYMMDD, they have a relationship with SKDate in my DimDate table (one active, one inactive)

     

    I want to use both FKInvoiceDate and FKCreditDate in a measure or calculated column, so I need to use USERELATIONSHIP somewhere.

     

    Hope this makese sense I'm unable to upload this as it's work related.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      Hi,

       

      Create a dummy dataset and share the link of that dummy dataset.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi Kashinoda,

      Have you resolved your issue?  Please refer the solution AlbertoFerrari posted. If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

      Best Regards,
      Angelia