Forum Discussion
Unexpected result with time function
Good morning, I'm having a problem finding where I'm going wrong in my model. I need to count the number of requests from the last date available in my database for each directorate. Those indicated ...
Hi hudsonvj ,
Based on the description, try to create a measure to identify the latest date.
LastRequestDate = MAX(fWorkflow[Request Date])Then, using the following formula to calculate the requests.
RequestDiaEmitted = CALCULATE(
[Request Qty.],
FILTER(
fWorkflow,
fWorkflow[Request Date] = [LastRequestDate]
)
)
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good afternoon. Thanks for the feedback. Unfortunately it hasn't worked out yet. It gave the same result. Something in my model must be generating the incorrect result and I can't identify it.
In fact, I need to use a temporal function more, as I will need to perform four scenarios.Number of requests on: day, week, month, and year. That's why I was using 'DATESBETWEEN or DATESINPERIOD
Result with the structure you suggested.