User Profile
im_newbie_123
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
DAX Switch statement error
Column1 = SWITCH(True(),[ID] = "FH20-10","YES",[ID] = "FA30-10","YES",[ID] = "FA60-20","YES","NO") I am trying to create a caluclated column named "Column1" and is getting this error : Function 'SWITCH' does not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values. Any help would be highly appreciated. Thanks in advance1KViews0likes1CommentRe: Issue - Scheduled refresh failures
Facing similar issue from past few days. The daily scheduled refresh fails. Something went wrong There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Credentials are required to connect to the SQL source. (Source at raproddbsz01.database.windows.net;sz.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"raproddbsz01.database.windows.net;sz"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceReference","detail":{"type":1,"value":"{\"protocol\":\"tds\",\"address\":{\"server\":\"ra*******.database.windows.net\",\"database\":\"sz\"},\"authentication\":null,\"query\":null}"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"CredentialMissing"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SQL\",\"path\":\"ra*******.database.windows.net;sz\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"CredentialMissing"}}],"exceptionCulprit":1}}} Table: Employment History SaleOps Format. Activity ID: 7cb1eda8-90e7-46e1-84bf-aebf0d98d3ee Request ID: 58b926b6-06b2-46ca-9227-17c78004537e Time: 2020-06-12 10:34:01Z The data model updates properly when refreshed from PowerBI desktop.4.3KViews0likes0Commentshow to filter data based on starting date of current running year
I am creating a measure to filter data based on starting date of current year upto now. My DAX : Calculate(Count(EmpID),Table1[Termination Date] >= STARTOFYEAR("2019-1-1",Getdate()),Table1[Termination Date] <= NOW()) This does not work. Any Suggestions ?Solved883Views0likes2CommentsHow to show average and total together in report view
I have to show average = row data total/count of month number. Total = column data sum Expected output: M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 M11 M12 Average* John 72 71 51 52 51 49 49 53 52 56 Mary 97 93 94 94 95 95 93 97 95 95 Sam 252 251 249 251 254 259 262 260 266 256 Hans 301 300 299 299 296 294 293 301 295 298 Samuel 160 153 152 153 159 160 160 157 159 157 Henry 683 689 686 697 717 707 714 717 707 702 Zaltan 48 47 47 51 48 49 49 51 54 49 Messi 6 20 40 42 43 46 48 49 52 38 Rolando 13 13 14 15 15 15 14 15 15 14 Total* 1632 1637 1632 1654 1678 1674 1682 1700 1695 1665Solved927Views0likes3CommentsUse advanced power query editor to use SQL statement
I have a sql statement which is union of two tables. I want to use the sql statement inside advaced query editor. My SQL Statement : SELECT [ABC],[XYZ] FROM TABLE1 UNION SELECT [PQR],[YAA] FROM TABLE2 I have to create something similar to a view which will have union of these two tables along with a new name for the dataset.60KViews0likes3CommentsDax Function to calculate year with decimal values.
have two columns (Hire Date and Current Date) I have to find date difference between the two columns using the formula : (Current Date - Hire Date)/12 = Tenure (new column) Example : Current Date 10/23/2019 Hire Date 10/23/2018 Tenure 1.02KViews0likes1CommentHow to use related DAX function with concatenate
I have two tables (A and B). Table A has 4 columns. User ID First Name Last Name Preferred Name Table B has 1 column named User ID I want to create a new column named Person Name in Table B based on User ID where I concatenate first name, last name and preferred name. Example: Table A User ID First Name Last Name Preferred Name 123 Sam John NULL 4351 Samuel Hans Samu Table B User ID Person Name 123 John, Sam 4351 Hans, Samuel (Samu) Power BI creats a relationship between the Table A and Table B based on User ID I understand I need to use related DAX function and concatenate the columns. can i get the correct syntax.1.3KViews0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.