Daily cumulate without date in the table
Hello, Could you please help me to build the visualisation. I need my daily cumulate of sales and of budget on the same graph. My problem is that i don't have date in my budget table. I have DATEINT YYYMM type to link my DATES table, with SALES and BUDGET. BUDGET has values by month, working days and Values per day = Month Value/working days I have sales for random dates during the month. Sales daily cumulate works well: Sales: daily cumulate = CALCULATE(SUM(SALES_TOT[Value]),FILTER(ALLSELECTED(SALES_TOT),SALES_TOT[Date]<=MAX(SALES_TOT[Date]))) and my budget daily cumulate obviously doesn't work, because it doesn't have Dates, all I may get it's a flat line with the same ammount for each day (quick mesure with running total doesn't help) Thank you for any advice.Available days per week (planning)
Hi all, I'm new to the all the DAX formula. And i'm struggeling to find the solution. I want to get the hours available for each consultant grouped by weeks. Like this: Each day (except weekend) the consultants are able to make 8 hours. The consultants want to be able to see which weeks they have room voor new projects. When 8 hours are already planned on a specific day, they have no space left. The planning is recorded in the table Workorder. The days available have to be totaled per week. Unfortunately, I cannot assume that a consultant has 40 hours a week deducted by the planned hours that week. This is because, it is possible that consultant is planned twice in one day (more than 8 hours). I made the following formula thanks to the Forum. But unfortunately it doesn't work properly as you can see. Per date the available hours are correct, but when totaled per week it doesn't work. See below the formula: The table factworkorder[DurationTime] contains the amount of hours planned per date. It is possible that on a specific date there are no hours planned, so the available hours have to be 8 (1 day). Below the outcome of the formula above: How can I achieve this? Thanks in advance!
