Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create new table by SELECTEDVALUE

I want to filter my table based on a slicer.

 

Below is my working:

Created a Slicer for 'TestData'[Date] and selected the date 2020-10-6.

Created the following 3 measures

SelectDate = SELECTEDVALUE(TestData[Date])

SpecifyDate = DATE(2020, 10, 6)

Checking = [SelectDate] = [SpecifyDate]           'Result is True

Created following 2 new tables

Table 1 = FILTER('TestData', 'TestData'[Date] = [SpecifyDate])

Table 2 = FILTER('TestData', 'TestData'[Date] = [SelectDate])

 

However, the content of Table 1 is not equal to the content of Table 2

I would like to know how to change the formula in Table 2 so that the Table 2 will equal to the Table 1.

 

Thanks so much!

1 Reply