Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all! I have a table with some information about when workers validate some information. It has the following colummns:
Division: the division to which the worker belongs.
Department: the department to which the worker belongs.
User_code: the worker's user code.
Document_date: the date of document
Validation_date: the date on which the worker validates the document
Day: the day on which the worker validates the document. It is the result of the subtraction of the two date columns.
Lack of validation: If the worker has validated the document, "NO" will be displayed. If not, the field will be blank.
Based on this information, I am trying to create a graph/table showing the evolution of the validation percentage distributed by days ("Day" column).
So I made this measures: (note that every row is a document that should be validated)
In the % cumulative validation is not making the addition properly.
Also If I filter the table by the column "Division" the result in not correct.
Could you please help me??
Thanks in advanced. I've attached the .pbix
Hi @pva ,
What is the actual business logic? Besides the fact that there is an error in the filtered value 610? Is it filtering the results correctly?
Looking forward to your reply.
Best Regards,
Henry
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |