Forum Discussion

w2zahn's avatar
w2zahn
Frequent Visitor
7 years ago

Related Function in Direct Query with new calculated column

Hi masters, That's my first complex calculation using conditions (if) for different fields. I couldn't do one step which is check if the date is a holiday. I'm struggling to do it in a measure so ...
Need Help
w2zahn's avatar
w2zahn
Frequent Visitor
7 years ago

Hi Lin,

 

For calculate how many minutes between two dates, you could use DATEDIFF Function.

 

Thanks for you tip, I'm using this fuction. You can find in the example linked in my first message.

 

What is your expected output?  could you please share some expected output based on this data?

 

The first goal is to validate if the date of the job was a holiday. As I explained in my first message. I couldn't find a way to do all the validations in one step as a measure.

 

The main idea is track the KPI of performance. That's why I do have the counters and gauge as showed in the example linked in the first message.

 

Thanks for your attention.

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, w2zahn 

You could try to add this conditional in a measure.

Filter( "Job", Job[BIPUDate] IN VALUES( Holidays[Date])) 

use this to validate if the date of the job was a holiday.

 

Best Regards,

Lin