locked
DAX filter a column value in a table based on date (current day and previous day) RRS feed

  • Question

  • Hi,

    I have a table,TestScores, that contains 2 columns (1) DateID (2) TestID there is another table,Calendar, which contains (1) DateID and other date related columns. The two tables are joined by DateID

    I am trying to find distinct TestID which were present yesterday but were not present two days ago, the filter should apply to any selected date filter applied to a report using the Calendar table.

    Thanks for the help!

    Regards

    Friday, September 21, 2018 10:59 PM

All replies