Dynamic labeling at row level basis selection of a filter

[Anonymous]

Hi Everyone,

I am trying to label all transactions at row level which should be dynamic basis selection of date.

For eg.

My original data table is in below format

Invoice	Date
1	01/01/2019
2	16/01/2019
3	31/01/2019
4	15/02/2019
5	02/03/2019

I am trying to create a column which should show results as below:-

if the date selected is 31/03/2019

Invoice	Date	Status
1	01/01/2019	Overdue
2	16/01/2019	Overdue
3	31/01/2019	Overdue
4	15/02/2019	Overdue
5	02/03/2019	Overdue

if the date selected is 31/01/19

Invoice	Date	Status
1	01/01/2019	Overdue
2	16/01/2019	Overdue
3	31/01/2019	Overdue
4	15/02/2019	Current
5	02/03/2019	Current

[mussaenda]

hi, @Anonymous 

I added a date table as the selection of the dates and created a measure to show the overdue and current situation.

Please refer to the screenshot below.

[Anonymous]

@mussaenda 

Is there any other way to create the same calculation using Column. Basically, I want to categorize all transactions at row level to show % Overdue and % Current. I understand it will not be possible using a measure.