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 ...
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.

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