Forum Discussion
Dynamic Status for pragmatic report
I currently have 2 data sets List if employees with training date and employee ID List of work done with date of work done and employee ID (Note: single employee has done multiple jobs in one d...
Hi Anonymous ,
I think we need to create a date table and then create dax to determine the date of work fields that meet the conditions for the date. But if you want to judge by month, you need a separate formula for each month and then add it to the table visual.
If there is still confusion, please refer to the following blog to provide relevant test data (remove sensitive information) so that I can answer you as soon as possible.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.