Hi - I will be glad if you can help me to solve following: My current table consist of manufacturing Order which includes 3 operations (sometimes more) and a final plan date for the last ope...
Hi, I have data from table1, table2, table3 each with different data sources. Within this dataset, measures such as (0-1), (02-05), (06-11), (12-24), and 24+ are derived through distinct calculatio...
Hi, power query m converts text to numeric but loses the 0 at the beginning of the number. For example: 0012 becomes 12 0123 becomes 123 try Number.FromText(text as text) as number or ...
Hi there, I am currently setting up a forecast query for project controlling. As you can see in the attached snip, I have "Current Budget" as initial value with Index 0. In a new column the ...
Morning All Ive seen so many threads on this but none of them helped me. I was also not sure on whether I should post in Desktop or here. Today I had this error on my...
Hi, In power query i have a date table. I want to exract the number of the week. However it starts the week on Sunday. How can i change it and start the week from Monday. For example, I want to see ...
Hello everyone, I have a table like the one below, and I wanted to tranform it to two different structucture. The sample of original table is: 1. First I want to tranform ...
I need to join two tables (add the Purchose order column to the table 1) by matching part number and serial number and copy the column with the corresponding purchase order number in table 2. ...
I am trying to replicate the API call which includes refresh of an access token as described here: https://community.fabric.microsoft.com/t5/Power-Query/Refresh-token-api-call/td-p/937553 ...
Hi everyone, I am a Power BI novice and need help with creating a new table using columns from another table. The original table is very large, with a lot of other columns, but I summa...