Formule of DAX
“Plan” (which has an id resource and how much we plan to get from it a unit)
“Rules” (in which information who when and at what time worked on the resource)
It is necessary to counter the plan on the resource to put the id of the employee who is currently working on it.
You need to make a formula.
which will be viewed in the "plan" table on "from the resource"
Go to the “Rules” table.
Find the field.
Status = Active
“From Resource” Plan = “From Resource” Rules
Look at the field of “Customer”
and transfer the value to the plan table
Applications 1
Client's review of cooperation with Taras Mosiienko
Formule of DAXEverything was made perfectly.
Freelancer's review of cooperation with Oleh Ilchyshyn
Formule of DAXThe only disadvantage is the failure of the time of active visit to the site and therefore a slightly delayed exchange of opinions. The rest was correct and adequate.
-
759 4 0 I did, only one column should be added to the list of rules (this can be hidden so that it does not melt). But the formula on the plan list does not verify the case when the same resource is developed by different workers (i.e. two or more active). But the formula according to your criteria gives 29 workers for An[2056420] and for 2022.9, and for 2022.10, i.e. They don’t look at dates.
-
453 5 0 Good morning, I did as I understood the task, contact me, I will show you what happened.
-
Результуюче поле "співробітник" - це ID_Employees?
-
Current freelance projects in the category Web Programming
Development of a WebGL/Three.js scene with generation and export of 3D (snapshot) from an animated shaderObject Description:The project is a designer table shaped like a realistic, deep whirlpool (a central vortex that smoothly transitions from a wide horizontal tabletop to a thin elegant leg). Task Essence:A WebGL / Creative Coding developer is required to create an interactive 3D… Javascript and Typescript, Web Programming ∙ 3 hours 1 minute back ∙ 14 proposals |
Create a website on WP, without a builder.
357 USD
Need to create a catalog (most likely without a cart) just a product request form without using Elementor and others there should be a main page, product page, catalog, supplier catalog, and possibly a few others design and style like this… Web Programming ∙ 3 hours 8 minutes back ∙ 58 proposals |
Shopify developer for sushi delivery website (Poland)We are looking for an experienced Shopify developer to implement a food delivery website (sushi) for a client from Katowice, Poland. What needs to be done: Set up the site on a ready-made Shopify template (template to be agreed upon) Menu with photos of dishes and descriptions… Web Programming ∙ 4 hours 33 minutes back ∙ 29 proposals |
Webflow developer for filling portfolio pages on the websiteA website custom-built on Webflow for a construction company needs to quickly fill project pages using one template (replace images and texts) For 2 languages Quantity - 6 pieces Ready to start asap, thank you! HTML & CSS, Web Programming ∙ 20 hours 28 minutes back ∙ 36 proposals |
LearnWorlds Administrator-ConfiguratorTask Set up the ready-made LearnWorlds platform for an elite online course. Do not develop the architecture — implement the already prepared structure manually in the admin panel. ———————— What needs to be done: Branding ⦁ Connect your domain ⦁ Upload the logo, set up… Content Management Systems, Web Programming ∙ 23 hours 33 minutes back ∙ 9 proposals |