Forum Discussion
Helper IShow Date Associated to Columnx(X) Row/Value
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.
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
2 Replies
v-danhe-msftMicrosoft Employee
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
- 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