A function "PlaceHolder" has been used in a true/False expression that is used as a table filter .
Hi There, I am trying to create one measure where i am tryin to get Sum of Session Duration for Distinct Session Id's for each process name . in SQL we can do like this : Select Session Id , Sum (Session Duration) From XYZ Table where Process Name="X" Group By Session ID However when i am trying to replicate same logic in DAX i am getting below mentioned error : Session_Disticnt Count is a measure which i have created to get Distinct Values of session id's Request anyone to help in solving this issue . Thanks, Ash amitchandak Ashish_Mathur
Replicating Minifs date in power bi
Im trying to create a measure that will enable me to generate the "Sales order date for return" columns available: key(which is the customer&order item), sales order date & return order date in excel, sales order date for return = MINIFS(B:B,A:A,A2,B:B,">="&(C2-15)) Thanks!How to make RANKX function rank based only on the first row group and exclude the other row groups
Hi, I have a rank function that needs to be calculated based only on Column1. Even if I add two or three other columns, the ranking should always be based on Column1. How can I ensure that my DAX formula ignores all columns except Column1 for ranking ? Note: Column1, Column2, and Column3 are from different dimension tables. MEASURE : RANK = VAR COLUMN1 = FILTER( ALL(D_COLUMN1_TABLE), CALCULATE( SUM(F_SCORE[SCORE]) ALL(D_COLUMN2_TABLE) ) <> 0 ) RETURN RANKX( COLUMN1, CALCULATE(MAX(D_COLUMN1_TABLE[NAME])) , , ASC, Dense ) This is the result i got:Calculate values for the previous trading day when weekends are excluded
Hi. I want to calculate a measure to see required margin for the previous trading day. The dates I have in the table include all dates. I have tried tried a function as shown below. It doesnt show required margin for the previous trading day for weekends and holidays. On the start of the week (monday), it usually shows 0. On the report date it should show the required margin on last friday. How can I make a measure for required margin from the last tradingday when weekends and holidays are excluded?
