Create couple of Total in table
Hi everyone, i would like to know if it is possible to have many Total in one table. I mean, I want to display General Total but also DOOH total and Print total in the same table. Do you know if we can create that? Maybe there is a tip? Please, have a look below my table. Thank you for your help, Lena
Cumulative Amount for the table and Chart
Dear all, Will be very thankful if you could help me to solve three problems related to cumulative amount. I have calculated the cumulative amount for employees (taking into account the employee Start and End date). Used such formula: Employees, Cumulative count = VAR CalendarMin = MIN('Calendar'[Date]) VAR CalendarMax= MAX('Calendar'[Date]) RETURN CALCULATE( [Employees count], Employees[Start Date] <= CalendarMax && (Employees[End Date] >= CalendarMin|| ISBLANK(Employees[End Date])), DATESINPERIOD('Calendar'[Date], LASTDATE('Calendar'[Date]), -10, YEAR)) The Cumulative amount appears correctly: 11. 1. Is possible to show in the table "Total" 11 instead of 21?| 2.The same problem appears in "Card", it shows 21 instead of 11. Is it possible to somehow modify the formula to get the correct cumulative amount of employees? 3. I also need to show the result in bar charts but again the total amount appears incorrect - 21: Thank you in advance for help!in time cumulative total using SCD history table
i have a SCD type 2 (History) table which has claimhistoryid unique key, this key is connected to fact table using 1 to many relationship. fact is also connected with date dimension as shown in the image below. i need to calculate two measures, one to sum the base transaction amount, which works fine. I need to calculate cumulative total value based on historical records. Also performance is critical because fact and history table are large tables and we use azure as tabular models. see example below, can you help?Power BI - Accumulate over time, and Percentage
Hi Guys, I need your assistance here as I am new to Power BI. November 2021 FIT should be 159 and not 157, and December should be equal to the total of the year as the table should accumulate over time. January 2022 will therefore need to include to total / December 2021 figure in order to continue this journey I’ve made a small pivot on the data extract, and here you can see, how the FIT% should look on a total basis across requirements: The above should somehow be presented in a graphical way taking into consideration that total no. of requirements is increasing over time, and that GAP’s can turn into FIT’s and vice versa. ------- In the table below: Is it possible to add a percentage in the bottom that just calculate the FIT% meaning in September it will be 100%, then it goes down to 67,37 in November and so forth? Looking at the FIT graph above – September is correct, November is close to it, but I start having hard times – It seems like the GAPS are taking more and more of the majority in relation to the total and therefore this also indicates that no accumulation takes place over time. In February I don’t even understand the blue box, because there are very few requirements falling into this group. So the red part should overtime be less, less and less taking into consideration that the total number of requirements is growing up to 497 in February starting at 238 in November. Then (and this is just an idea) for each cell in the above you can then calculate the estimated no. of hours as the sum of requirements, where ((Max dev. Effort – Min dev. Effort) / 3) times 4) gives the value in hrs.
