EN VI
Tag thumbnail
Powerquery
0 Posts
7 Questions
Posts (0)
Questions (7)
Avatar
Best Solution Bot
2024-03-10 00:30:06
Powerbi - Stacking Multiple 2x2 Columns into Two Columns in Power Query?
You probably want to remove the index column first, but you can use this pasted into home ... advanced editor ... change the groupsof number for number of columns you want to stack as a group, and cha...
Tags: powerbi,  powerquery,  m
Avatar
Best Solution Bot
2024-03-12 00:00:07
How to convert data into a table in Power BI after integrating an API with JSON data?
Try combining those data columns into a table and then expanding let [...] // Converter a resposta JSON em uma tabela jsonResponse = Json.Document(response), #"Convertido para Tabela" =...
Tags: json,  powerbi,  powerquery
Avatar
Best Solution Bot
2024-03-12 16:00:05
Powerbi - Variables (column names) differ between power bi and power query?
The only possible reason is that the query is not successfully refreshing and loading into Power BI so you're still seeing the old data and column names.
Tags: powerbi,  powerquery,  data-analysis
Avatar
Best Solution Bot
2024-03-12 16:00:11
Excel - Passing table source as variable - Power BI?
Try this: Table.Combine(Expression.Evaluate(cnsList, #shared))
Tags: excel,  powerbi,  powerquery
Avatar
Best Solution Bot
2024-03-13 17:30:09
Excel - Sorting rows and leaving blanks in their position?
Try this in powequery let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}}), #"Duplicated Column" = Table.Duplicat...
Tags: excel,  powerquery,  data-cleaning
Avatar
Best Solution Bot
2024-03-14 16:00:08
Powerbi - Remove duplicate names from Name column - Power BI?
In PQ go to menu Add column > custom column and past below function, replace column1 with the name of your column: Text.Combine(List.Distinct(Text.Split([Column1]," "))," ")
Tags: powerbi,  dax,  powerquery
Avatar
Best Solution Bot
2024-03-15 10:00:08
Powerbi - Power BI -- return data based on previous column value in query editor?
You did not specify what you wanted returned in the third column if the second column contained neither Agree nor Disagree. I returned a null, but you can easily change that. The algorithm consistis...
Tags: powerbi,  powerquery,  powerbi-desktop
Pinned Posts
Top 5 Best High CPM Ads Networks For Publishers In 2023
Tags: ads,  Publishers,  Ads Networks
2022-05-24 10:11:32
HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day
Tags: Server,  host,  cloud
2022-04-15 16:23:09

Login

Forgot Your Password?

Create Account

Lost your password? Please enter your email address. You will receive a link to create a new password.

Reset Password

Back to login