Help with ISBLANK function
Hope someone can help with this ISBLANK function: # Tables with no person assigned = CALCULATE(DISTINCTCOUNT(responsibility[table_id]),(responsibility[role_id]="Engineer" && ISBLANK(responsibility[user_id]))) It is currently not returning a number, so I must have done something wrong here. Appreciate any help!
Check every 15 days
hello, tell me how to implement the following task in POWER BI. Thank you! What is: - the date of the operation - email (not unique) - transaction amount - whether the payment was confirmed or not I need to find/calculate: - for each user (email), the first and last transaction (amount) - but such a "procedure" should take place no more than 15 days after the FIRST operation. For example 1, the client made the 2nd operation 16 days after the first, then it will appear twice in the report, because more than 15 days have passed. The amount of the first and last transaction for this client will be equal. For example 2, the client made the 2nd operation after 10 days, it will be in the report once, but with different amounts of the first and last operation. For example 3, the client did the 2nd surgery after 3 weeks, the 3rd after 4 weeks. We need to "merge" data for 3 and 4 weeks. The client will also be in the report twice.
TOTALMTD date parameter is causing incorrect results
I want to get the MTD and YTD amount of hours worked from our table containing employee hours worked for a given week. I'm new to Power BI and DAX and can't get the TOTALMTD or TOTALYTD functions to work right to save my life. The documentation shows the syntax as: TOTALMTD(<expression>,<dates>[,<filter>]) It explains that the dates parameter is "A column that contains dates." Okay, but that's so vague it's not helpful. I have a calendar fact table that is joined to the employee hours worked table. When I use the calendar date column in our calendar fact table, as most people do in their examples, the function returns nothing (but does not give any errors): Hours_MTD = TOTALMTD(SUM(Time_Recorded[Total Hours Applied]),DIM_CALENDAR_CURRENT[CALENDAR_DATE]) When I use the week ending date column in the employee hours worked table, the function returns numbers that are impossibly high and verified as incorrect: Hours_MTD = TOTALMTD(SUM(Time_Recorded[Total Hours Applied]),Time_Recorded[Week Ending Date]) It seems so simple, but why is the function not working right? I can't find any explanations of what column should be used for the date parameter other than the calendar fact table.Excel function to DAX
Hi, I need some help converting an excel formula into DAX. Excel: =DATE(YEAR(TODAY()),MONTH(TODAY())-[@[- Months]]+1,0) - Months = is a selection with the month number values (1 thru 12) Result should be: YYYY-DD - Months Day 1 2022-04 2 2022-03 3 2022-02 4 2022-01 Any help will be appreciated. Been trying to convert this fucntion for a couple of days now. Thanks.How to use IF Function to reference two tables for a result that is filtered by both tables
Hi there, I am trying to work out how many Workspaces from a data dump have successfully installed an agent, by using another table with the list of workspaces as reference. Table 1 = Data dump of all machines with the agent installed Table 2 = Directory of all Workspaces I want to be able to create a calculated column that says either Workspace or Not Workspace in Table 1, so that I can easily filter which of the rows of installed machines in Table 1 are Workspaces. I look forward to a response 馃檪 CheersParticipaci贸n de un producto de acuerdo a su aparici贸n
Hola Chicos, En esta ocasi贸n estoy queriendo responder la siguiente pregunta: Cuales son las combinaciones de productos que mas se dan por cada compra que realiza el cliente, pero en este caso que se pueda seleccionar el producto a ser evaluado. Todo esto en Power BI Desktop. A continuacion unos datos de ejemplo: Datos de ejemplo: Id Productos Nombre Prod ID Transaccion 30 Vitamina 9001 30 Vitamina 1001 40 Agua 1001 30 Vitamina 3001 40 Agua 3001 10 Ponstan 3001 30 Vitamina 4001 40 Agua 4001 10 Ponstan 4001 10 Ponstan 5001 80 Jugo 2001 Resultados: En la variable Productos, me salen todos los productos existentes. En la variable Apariciones, me salen todas las apariciones de cada producto por cada ID de transacci贸n diferente en la que el producto Vitamina aparece. En la variable Porc%, es la participaci贸n de cada producto de acuerdo a su aparici贸n. Mas espec铆ficamente esta variable es la divisi贸n entre la aparici贸n de cada producto y el m谩ximo de apariciones del producto seleccionado. Por ejemplo: 4/4 = 1 (aparici贸n del producto)/(M谩xima apariciones del producto a analizar) = 1. Nota: Quisiera hacer esto a traves de DAX en Power BI. Quedo atento a sus respuestas, De antemano muchas gracias, Saludos,Dax - switch function
hi all , DAX is A new language for me (: i have column "postion name" & "Actual amount" most of them come directly from the DB and some are calculated like 'NRI' is calculation of "GRI" + 'LRI' when i use SWITCH(TRUE() function: i use this option: ---- return SWITCH(TRUE(), MAX('9 - Controling'[POSITIONS_NAME])="NRI" , CALCULATE(sum('9 - Controling'[Actual Amount]),'9 - Controling'[POSITIONS_NAME])="GRI") ---- I received this error message : dax comparison do not support comparing values of type number with value text thanks, sinayha
