Forum Discussion
filter comparing two column
- 4 years ago
Hi sainig546 ,
Yes you can achieve this by creating a flag as a calculated column and use it in your filter pane.
I am assuming you have created date column in your data in Power BI, then you can create this clculated column using DAX:
date_comparison_flag = IF ( yourtablename[Created Date] = TODAY (), 1, 0 )Make sure to replace the yourtablename[Created Date] this with your table name and column name.
This above calculation will give you a column date_comparison_flag with values 0/1.
Then use this column in the filter pane to select date_comparison_flag = 1.
This will filter your report page where created date = today's date.
Thanks,
Pragati
- 4 years ago
Hi sainig546 ,
You can create a measure like below and use it as filter in your visual:-
Measure = COUNTROWS(FILTER('Table','Table'[created date] = 'Table'[updated date]))Thanks,
Samarth
Hi sainig546 ,
You can create a measure like below and use it as filter in your visual:-
Measure = COUNTROWS(FILTER('Table','Table'[created date] = 'Table'[updated date]))
Thanks,
Samarth