Forum Discussion
KPI based on Datetime
Hi All, I have a series of tasks 1 to 60 (rows) with different dead lines (datetime) and different locations (attribute) record 'done' when they have completed the task. The requirement is if ...
The date and deadline columns are not the same type? One of them is Text for some reason? If yes, change it to data or datetime before you bring it to the model (in Power Query for example).
Than you sould be able to write something simple like:
KPI Column = IF('Data'[Deadline] > 'Data'[Deadline] && 'Data'[Value] = "Outstanding", 1,0)
Also you don't need a column for that calculation, do it in a measure and than use it in the conditional formating settings of the visual: