calculate days count between 2 dates
Hello Everyone I want to calculate days starts with item purchese date to item transfer date , items can be more than ones in the table it means can be purchesd more than ones and for all branches , I want to calculate the days for each branch and sorted by dates if there are more than one purches order Here is the source table item transaction number type date decs branch A 01 3 01-01-2024 purchase order A A 01 22 10-01-2024 Transfer order A A 02 3 07-01-2024 purchase order A A 02 22 14-01-2024 transfer A B 03 3 01-01-2024 purchase A B 04 3 01-01-2024 purchase B B 03 22 13-01-2024 transfer B I want to Get the result like this item transaction number branch Days Count A 01 A 9 A 02 A 7 B 04 B 12
Measure for new clients based on the year filter
Hello! I have a table with clients and their respective contracts, each client can be a new client or a recurrent one. A new client is someone who had his/her contract for the first time - referent to the selected year in the year filter, for example: selecting the year "2022" on the filter, we have the contract(s) of the client X, who didn't have any other contracts prior to 2022, therefore he is a new client; however, if I select "2023" or higher, and he has another contract that year, he is not a new client anymore because he already had one in 2022, then he is a recurrent client. My question is: how can I make a measure to filter between new/recurrent clients? I need to distinguish how many clients and the total value of the contracts in each year, for both categories. Thanks in advance!
Acumulated production
Hello I want to calculate the acumulated production per year, task and ID, like in the following table, can you help me? ID TASK YEAR PRODUCTION Accumulated production 0 1 1 -80 -80 0 1 2 100 20 0 1 3 110 130 0 1 4 105 235 1 2 1 -50 -50 1 2 2 -60 -110 1 2 3 -80 -190 1 2 4 100 -90 1 2 5 200 110 1 2 6 300 410 2 3 1 -89 -89 2 3 2 -74 -163 2 3 3 -50 -213 2 3 4 -20 -233 2 3 5 500 267
