Hi, I am trying to combine two files from a folder. I came up with an error message. I'm not sure what I'm doing wrong. I am a novice at PQ, so any help is much appreciated. For context, I ...
I have rquirement to change the Epoch datetime to readable format , i am using the below query which is giving me right answer for GMT +5.00 & when i add GMT +5.30 it gives a error.. each #datet...
I have a 2 tables, both has the same column names col1, col2. Table1 has more data (1000) and Table2 has subset of Table1 (300). I am trying to get the rows into another table which are exists only i...
Good afternoon, I need help with the following case. If anyone could help me, I would appreciate it. I have a table where in the 'request' column there are duplicate values because there are values i...
hi dears i am using power query and i am facing a complicated issue with time format. i have a data with mixed 12 hours, 24 format . i need to know how to get them all as the same format . i treid u...
Hi all, In PowerBI, I am trying to connect my new lakehouse as data source. Unfortunately, I cannot make it work. The steps I do: first, I click OneLake data hub, then Lakehouses. ...
I am trying to do a lookupvalue formula on filtered data. I am having issues combining the two. The goal is as follows: Filter table 1 to only return values that = a sepcific value in a column....
I am trying to Calculate Sprint Commitmment.There are some stories that are not completed in the same sprint and gets moved to next sprint.In such cases i dont want to add this story points twice. He...
I'm trying to translate my IF/ Sum IF formula to DAX. I basically want to show the quota attainment for each employee but based on their position. So if they are a manager then the total of the teams...