DAX - RELATING VALUES TO NUMBERS

Question

Hello everyone, I have the following problem, I would need to create time ranges, that is, classify a number of people by the company and the time at which they arrive, as conditional to say, if a person corresponds to the company xy their arrival time is equal to the entrance (08:15) then give me as a result that meets, however if their arrival is greater than or equal to 09:40 , give me as a result that you have a delay and if you are over 10:30, it does not meet! In short, it would be to put a condition by mixing the company name with the schedule, is it possible?

v-luwang-msft · Accepted Answer

Hi&nbsp;Syndicate_Admin&nbsp;，
arrive time&lt;=08:15，meets
arrive time&gt;=9:40&amp;&amp;arrive time&lt;10:30，&nbsp;you have a delay
arrive time&gt;=10:30,not meet
Is like this?
&nbsp;
measure =
IF (
    MAX ( 'table'[arrive time] ) &lt;= "08:15",
    "meets",
    IF (
        MAX ( 'table'[arrive time] ) &gt;= "9:40"
            &amp;&amp; MAX ( 'table'[arrive time] ) &lt; "10:30",
        " you have a delay",
        IF ( MAX ( 'table'[arrive time] ) &gt;= "10:30", "not meet", BLANK () )
    )
)
&nbsp;
If not like this ,could you porvide a sample?
&nbsp;
Wish it is helpful for you!
&nbsp;
Best Regards
Lucien
&nbsp;

Forum Discussion

DAX - RELATING VALUES TO NUMBERS

1 Reply