powerquery
3 TopicsErro de Visualização Power Querry
Good Morning I'm using powerbi using postgreeSQL as a data source, connecting via ODBX When I load the tables and enter powerQuery for editing, some appear the following message "Preview.Error: The current preview value type is too complex to display. Details:" What could I be doing to fix it?753Views0likes2CommentsTransforming data
I have a data set that looks like this: With 50 Teams and dates spanning from Jan 2019 up to March 2022. How do I include all the month and year in each column such as the number of hires, voluntary terminations, total terminations, headcount and percentage will have the month and year as header? so that I can just unpivot it later. Can I do it in powerquery or powerbi?Solved1KViews0likes2CommentsNeed Mesure to calculate average days
I have SharePoint list like below. I need an average days between CreatedDate and DueDate. Like: first item difference 20days and second item difference 30days and third 40days..So on if 10 items are there 20+30+40+...so on÷10 items..caluculate need for new colomn measure in PowerBi. PLZ HELP Title CreatedDate DueDate Item1 13/12/2021 01/01/22 Item2 14/12/2021 02/01/22 Item3 15/12/2021 03/01/22 . . . .....So On..Solved1.1KViews0likes1Comment