Forum Discussion
Related Function in Direct Query with new calculated column
hi, w2zahn
First step, calculate how many minutes between two dates (I created a new column to do this || yes, I know that I don’t need a new column to get the information but because I need this information to use in the other calculations and I couldn’t create all of then in a measure, I break in steps to make easier but I’m still missing one bit)
For calculate how many minutes between two dates, you could use DATEDIFF Function.
What is your expected output? could you please share some expected output based on this data?
Best Regards,
Lin
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.
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
