Measure to display status

[sgeheeb]

Hi,

I am trying to do display the status of data processing in a table as such:

Date	Status
10.06.2020	finished
11.06.2020	finished
12.06.2020 (today)	in progress

The condition is very simple: If the date is today I want to display "in progress", for older dates I want to display "finished". The [Date] column in already in my data model (in a date table, along with other columns).

I know this can be done easily with a calculated column and a simple condition. It works fine if I do it in Power BI Deskotp / Service. However, the data model is supposed to the viewed as a pivot table in excel (Analyze in Excel from the Power BI Service). The pivot table will not let me drag the [Status] column into the Values section (nor will it let me use anything besides measures). 

Can the behavior described in the table above be achieved by using a measure? Or does anyone know how I can use my calculated column in the pivot table? The latter would be my preferred option.

Any help would be greatly appreciated.

[amitchandak]

@sgeheeb ,

Is Today = if('Date'[Date]<=TODAY(),"Finised","in progress")

[sgeheeb · Accepted solution]

Hi,

thanks for your answer. This code works fine as a calculated column, but not as a measure.

I just figured it out! Like this it works for me:

1. Keep the calculated column (e.g. [IsToday]) as it is

2. Create a measure:

Stauts = SELECTEDVALUE('Date'[IsToday])

 and use the measure in the pivot table.

Thanks for your help!