Forum Discussion
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 ...
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.
Hi,
Create a dummy dataset and share the link of that dummy dataset.