User Profile

jozsacruz

Frequent Visitor

Joined 5 years ago

5 Posts

View All Badges

User Widgets

Contributions

Re: Time formatting keeps changing in report view in workspace.
Thank you for your response. The report screenshot I posted is also from my own PC settings which is set in PST. Do you know why it would revert back to its original timezone even after the changes in Power Query? Thanks!
5 years ago Place Desktop
748Views
0likes
0Comments
Time formatting keeps changing in report view in workspace.
Hello all, I wanted to ask if anyone knows how to fix the issue I am getting or if there is a work around. Essentially, I pull data with a GMT time format and when I upload into desktop PBI, it automatically converts into my local timezone in PST. However, when I publish the report into the workspace it reverts back to GMT timezone. Are there settings in our workspace that I need to change or in the desktop app that I need to adjust? I've provided screenshots below: 5am-6pm is the time I need, in PST and this is in desktop This is what happens when I publish the report in our workspace, the time goes back to 12am-11pm Thank you!!
5 years ago Place Desktop
Need Help
Tips and Tricks
863Views
0likes
2Comments
Sharepoint Folder
Hello, Just wanted to ask how I can merge excel files in power query. I have connected to my sharepoint folder and will be adding excel files weekly. These files remain relatively similar but sometimes may change from time to time. The only change is new columns will be added. Do I have to enter power query editor to add in the new excel file and append each time a new file is added or is there a way to automate it? Thank you!
Solved
5 years ago Place Power Query
Need Help
650Views
0likes
1Comment
Contar un valor en cada columna por semana
Hola Tengo una columna que dice pasar o fallar y estoy tratando de hacer un countif para hacerme saber cuántos pases o fallas tengo, pero quiero filtrarlo por semana. Tengo una fórmula DAX similar donde el uso de allexcept(nombre de tabla, columna de nombre) funcionó, pero cuando lo intento con otra vez, dice que W12 dice "No se puede convertir el valor 'W12' de tipo Texto al tipo Verdadero/Falso." Aquí está la fórmula que pude usar para obtener un valor semanal: Columna 1 á calculate(average('Table Name'[Column name ]), allexcept('TableName','TableName'[Week])) Esto es lo que tengo hasta ahora: Columna 1 á CALCULATE(COUNT('TableName'[ColumnName]),FILTER('TableName','TableName'[ColumnName]-"pass"),FILTER('TableName','TableName'[Week])) ¡Gracias!
Solved
5 years ago Place Translated Spanish Desktop
635Views
0likes
2Comments
Counting a value in each column by week
Hello, I have a column that says either pass or fail and I 'm tyring to do a countif to let me know how many pass or fails I have but I want to filter it by week. I have a similar DAX formula where using allexcept(table name, name column) worked but when I try it with again, it says that W12 it says "Cannot convert value 'W12' of type Text to type True/False." Here is the formula that I was able to use to get a weekly value: Column 1 = calculate(average('Table Name'[Column name ]), allexcept('TableName','TableName'[Week])) Here's what I have so far: Column 1 = CALCULATE(COUNT('TableName'[ColumnName]),FILTER('TableName','TableName'[ColumnName]="pass"),FILTER('TableName','TableName'[Week])) Thank you!
Solved
5 years ago Place Desktop
Need Help
762Views
0likes
2Comments

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.