accumulate
2 TopicsAcummulated tickets along time - Show acummulated after today - Cumulative Totals
Hi guys, I need your help... I'm trying to show the accumulated open tickets along the months, but on visuals they extend until december. I would like to see until the current month, I have try almost everything, but not worked, even the ChatGPT could give me a good answer. You are my last hope. I use this measure: CALCULATE ( CALCULATE ( COUNTROWS ( f_Suporte ), FILTER ( ALL ( f_Suporte[##Related Status_Cliente] ), f_Suporte[##Related Status_Cliente] = "Ativo" ), FILTER ( ALL ( f_Suporte[##StatusTicket] ), f_Suporte[##StatusTicket] = "ABERTO" ) ), FILTER ( ALL ( Date_Table_TR[Date] ), Date_Table_TR[Date] <= MAX ( Date_Table_TR[Date] ) ) )Solved830Views0likes2CommentsAcumulate fortnight
Hi, I´m new here and have a doubt about DAX. Yesterday I was dealing with the purchase attachment and wanted to create a table with the following information: Knowing that the supplier ship on the 15th and 1st of each month, I wanted a table that would accumulate those purchases on the days they ship, to get a table showing how much quantity I will receive on each day. I tried to do a DAX measure with MTD and with this I was able to get the 15th day, but I am not able to get the 1st day. Any suggestions? Thanks. Date Purchases 2022/01/05 706 2022/01/10 1312 2022/01/22 806 2022/01/27 210 2022/02/02 1037 2022/02/10 1808 2022/02/17 1311 2022/02/25 1793 2022/03/03 1500Solved855Views0likes3Comments