Time Intelligence DAX

Time Intelligence DAXFollow
Phaneendra Adusumilli
Phaneendra AdusumilliApr 21, 2022 06:20 AM
I have data like this So whenever my system time match to “IN” time value in the column then …
1. Time Intelligence DAX

Bronze Contributor
Phaneendra Adusumilli
Posted Apr 21, 2022 06:20 AM
I have data like this

So whenever my system time match to “IN” time value in the column then I want to show in Status column as “Occupied” and whenever the system time match with “OUT” time value in the column then I want to show in Status column as “Available”. So, from 8:00:00 to 17:00:00 I want to show status as “Occupied” and after that onwards I want to show it as “Available”. Like this I want to show it for all rows. How to do this.

——————————
Phaneendra Adusumilli
——————————

2. RE: Time Intelligence DAX

Adam Artur Boltryk
Posted Apr 21, 2022 12:28 PM
Hi Phaneendra,

You are asking for imposibble. You can not have variable in table column. Data in columns are calculated while table is loaded. So when you open file or hit ‘Refresh’.
It can be done only in a measure. However you have to remeber, that PowerBI is NOT live system, and you have to all time refresh your preview.

Regards

——————————
Adam Artur Boltryk
Business Analyst
——————————