Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Time Intelligence DAX

    Bronze Contributor
    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

    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
    ------------------------------