Show Date Associated to Columnx(X) Row/Value

[BlastS]

Date	ColumnO	Output	OutputExpected
02/02/2000 20:00	0	3	02/02/2000 20:30
02/02/2000 20:10	0		02/02/2000 20:40
02/02/2000 20:20	0		02/02/2000 21:00
02/02/2000 20:30	1
02/02/2000 20:40	1
02/02/2000 20:50	0
02/02/2000 21:00	1
02/02/2000 21:10	0

How to show the datetime of each value i got, for example, i got a column with values 0 1 , and i make a count (to count only = 1) , after that i would like to show the date which that columnx X = 1 is associated like i show on output.

How can i achieve this on powerbi, sounds simple but here not have a clue how to do it.

[v-danhe-msft]

Hi @BlastS,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @BlastS,

Based on my test, you could refer to below steps:

Sample data:

Create a new table:

Table = CALCULATETABLE('Table1',FILTER('Table1','Table1'[Output]=1))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He