Forum Discussion
How to combine two different date filters
Create a date table, marked as a date table, and link that to both your date columns in your fact table. Only 1 relationship can be active at once, but you can use USERELATIONSHIP to activate the other relationship when needed.
If you made the link to the PO Date the active one, then your measure for the $ amount would be something like
Dollar Amount = CALCULATE( SUM('Table'[Amount]), USERELATIONSHIP('Date'[Date], 'Table'[Dollar date]) )
Super UserCreate a date table, marked as a date table, and link that to both your date columns in your fact table. Only 1 relationship can be active at once, but you can use USERELATIONSHIP to activate the other relationship when needed.
If you made the link to the PO Date the active one, then your measure for the $ amount would be something like
Dollar Amount = CALCULATE( SUM('Table'[Amount]), USERELATIONSHIP('Date'[Date], 'Table'[Dollar date]) )
Thank you!! This worked on every level except now in my table it is also is giving me dollars outside of my filter with no info except the dollar amount. I tried filtering out all the blanks on this one table, but that did not seem to work. I am guessing there is a dax statement I can tack on to my Userelation formula to remove these lines.