Dax formula to select a row based on multiple criteria and eliminate duplicates
Hello - I am learning Dax and I am stuck with filtering a table and removing duplicates. I wish to filter the table to show the latest version of a contract, by contract id. My table consist of the following: Contract ID | Supplier | version | Descr | Begin Date | Expire Date | Max Amount | Line Released Amount | Contract Line number. I want a Dax formula that will return one line per Contract ID based on the latest version # of the contract. I am looking for the formula to return the data I manually highlighted in yellow. Is this possible? Thank You -
Different column output basing on Parameter Selection
Hi Guys and Welcome Everyone! my first post in this community :). I have following query. I have created parameter using "New Parameter" -> "Numeric Range" Then I have edited parameter settings as follows: Then I would like to have column with different output depending on parameter selection. I wrote formula as follows: When I test it in report view, I always get "NOTPASSED", whatever I choose in the slicer. Do I miss anything or is there other workaround to achieve my goal?
Formula To Excel
Pease give DAX for =-SUMIF(Details!B:B;'Cash Flow'!G34;Details!G:G)+4801. I have DebtorMovements = CALCULATE( -SUM('ZTBR'[Amount in USD]), 'ZTBR'[Roll_Up_Function] IN {"Debtor Movements"} ) + 4801 Is this correct? It gives me the value, but that same value then displays for all the rows, which should not be.
Please Help. WeekNum to Pay Period column/Formula
l'm creating a workbook for tracking meetings. I've just generated a pivot table calendar from a sheet with the following columns: "Date, WeekNum, WeekDay, Day, Month." It's great! However, I desperately need either the week number to align with the pay period calendar (starting on XX/XX/YR instead of 01/01/YR), or I need a column that is going to show the pay period week formulated off of the week number- but starting over at the end of the pay period year (So it can't just be a basic cell/value+#). Also, I'm COMPLETELY new to this, so I'm way in over my head with the formulas- but work is work. So, basically explain step by step what to do, or else I'll be lost. Thanks!Last 6 months completed
Hello everyone, I have a date table. I would like to be able to say whether or not the date I have in the date column is between the first day of the 6th last month and the last day of the last month. For example, today is 08/24/2023, I will have true for dates between 02/01/2023 and 07/31/2023 Thanks
Restar los registros creados en una fecha a los registros cerrados en la misma.
Buenos días, como están? Estoy intentando generar una medida que cuente los casos abiertos y los casos cerrados en una fecha determinada, pero solo logro que en la tabla me cuente los casos que se crearon en una fecha y cuantos de esos casos ya están cerrados: Por ejemplo, esta tabla cuenta correctamente los casos que se crearon en cada una de las fechas, pero NO trae cuantos casos se cerraron en esa jornada. Podemos verificarlo en esta otra tabla: Como vemos, en la tabla 1 se ve que los casos cerrados son 799, pero en realidad fueron lo que muestra la segunda tabla (421). Entiendo que pasa porque en la primer tabla las columnas año, mes y día provienen del campo "CreateDate" que es la fecha de creación del registro, y la formula que utilicé para contar los casos abiertos y los cerrados es la siguiente: Casos abiertos = COUNT(Caso[CreatedDate]) Casos cerrados = COUNT(Caso[ClosedDate]) Como las formulas cuenta las fechas de creación de los casos y de cierre de los casos, y al ser la columna de fecha del campo "CreateDate", power bi me cuenta cuanto de los casos con fecha de creación X tienen una fecha de cierre. En la segunda tabla, as columnas año, mes y día provienen del campo "ClosedDate" y por eso cuenta correctamente las fechas de cierre, pero si le sumo la medida "casos abiertos" vuelve a generar el mismo error. Me podrán ayudar a resolverlo?Need DAX help on Calculate, Count and Filter Functionality
I've tried an IF(AND and CALCULATE(COUNT but I am struggling to find how to exclude the possibility of some variables in a count formula. I need to return everything in a Column (Action Code) that is "UC" only for a specific prem # (in the left hand column). In the Matrix. UC is a Count of the Action Code. In some cases, the Prem # will pull in multiple Action Codes too. So I will get a UC with SC, but I need those omitted and only show UC and null(blank) elsewhere. Maybe I am overthinking the DAX, but I am struggling on this. I have at least gotten the UC's to all appear in the formula below, but need some assistance in getting the other Action Codes removed. I know I need to Filter out the counts, but unsure how to do this. Such as if UC and SC are both 1 counts, they will be removed from the matrix. CALCULATE( COUNTA('DataSet'[CRDT_COLL_ACTN_CD]), 'DataSet'[CRDT_COLL_ACTN_CD] IN { "UC" } )
Run DAX formulas based on values/criteria to produce the required output.
Hi ... I have data like below for my dashboard. So far I'm having trouble with the expected results for item no. 4 and no. 5 as table below. As we can see, the table above has values that indicate that the KPI indicator is either increasing or decreasing. Achievement column is the activity result for each items. How can I get the result as in column status?... Can someone help me and advise on this. Regards.
