User Profile

QuasemS

Frequent Visitor

Joined 10 years ago

13 Posts2 LikesLikes received1 Solution

View All Badges

User Widgets

Contributions

Re: Calculating day/time difference
I would get a raw number for that column. Do I format it using this: Hours = INT([Duration in Seconds]/3600) Minutes = INT(MOD([Duration in Seconds],3600)/60) Seconds = MOD(MOD([Duration in Seconds],3600),60) H = IF(LEN([Hours])=1,CONCATENATE("0",[Hours]),CONCATENATE("",[Hours])) M = IF(LEN([Minutes])=1,CONCATENATE("0",[Minutes]),CONCATENATE("",[Minutes])) S = IF(LEN([Seconds])=1,CONCATENATE("0",[Seconds]),CONCATENATE("",[Seconds]))
10 years ago Place Desktop
191KViews
0likes
4Comments
Re: Calculating day/time difference
Here's a snapshot of the two columns. I'm trying to find the difference between the second and the first one: So the result wouldn't be a date, but in days/minutes/seconds format.
10 years ago Place Desktop
191KViews
0likes
6Comments
Calculating day/time difference
I have two columns, both with dates and times in the same format. I want to create a new column to calculate the days/times differences between the two columns. But when I try to change the data type to date/time, it gives me an error which makes sense because it's looking for an actualy date, whereas I am trying to calculate the difference between two dates. Anybody know a good way to do this? Thanks
Solved
10 years ago Place Desktop
Need Help
191KViews
0likes
11Comments
Re: Change values in column based on range
I'm getting a syntax error when I try to do that in the Query Editor. The "greater than" sign is not valid.
10 years ago Place Desktop
8.1KViews
0likes
2Comments
Change values in column based on range
Hi, Is there a way to select a specific column, and then change some of it's values to something else, based on it's range. For example, I'm trying to change a percentage column, where anything > 100% should just be converted to 100%. Is there a way to set the conditions for value replacement in the query editor?
Solved
10 years ago Place Desktop
Need Help
8.1KViews
0likes
4Comments
Remove duplicates based on values
Hi, I'm trying to remove rows based on duplicate values in a column. I know how to use the Query Editor to do this. However, the duplicate values in that column has different values corresponding to it in the table. I only want to keep the record with the highest value in the other columns, and get rid of the duplicates with have lower values. When I do the regular remove duplicates step, it always seems to keep the lowest value. I want to do the exact opposite. Anyone know if there is some flexibility with this option where I can achieve this? Thanks!
Solved
10 years ago Place Desktop
Need Help
76KViews
1like
10Comments
Re: Color based on number value
That screnshot has actually been taken from Power BI, and I figured out how to do it. It's called 'conditional formatting' and can be found in the drop down menu for 'fields'
10 years ago Place Desktop
5.6KViews
1like
1Comment
Color based on number value
Hi, I am trying to create a table like this: But when I create a table, I can't seem to get the color to show based on the value. Basically I want the same thing which goes from 0-100 and red to green. I couldn't find any thresholds where I can set colors or anything in the table visual. Does anyone know how to achieve this? Thanks!
Solved
10 years ago Place Desktop
Need Help
4.3KViews
0likes
3Comments
Getting data from Gateway
Hi, I have our enterprise gateway servers setup with usernames and passwords but I can't seem to find how to retrieve the data from the warehouses. I can't find an option to connect to the gateway to access the databases. Can anyone tell me how to do this?
10 years ago Place Power Query
Need Help
2.5KViews
0likes
7Comments
Excel workbook Import error
Hi, I'm trying to import an Excel Workbook connected to a cube but Power BI tells me it doesn't contain any queries or model to import. Anyone have this problem before?
10 years ago Place Desktop
Need Help
9.5KViews
0likes
6Comments

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.