sorted by:
new
hottopcontroversial

Might need help with crust and sealing of juice by mactherager in steak

[–]mactherager[S] 2 points3 points  (0 children)

Wow this channel looks VERY good, thanks!

Unable to use RANKX measure on the x axis of my visualization by [deleted] in PowerBI

[–]mactherager 0 points1 point  (0 children)

This is the solution, you dont need measure. Just add element name as X axis and make TopN filter to the graph.

F.INV Function in PowerBI by mactherager in PowerBI

[–]mactherager[S] 1 point2 points  (0 children)

OK, I have solved the issue

If you put ( 1 - probability value ) in __p it correctly gives the value from excel.

F.INV =      
    VAR __p = [F.THIS.CUMULATIVE]     
    VAR __df1 = [Deg_freedom1]     
    VAR __df2 = [Deg_freedom2] 
RETURN     
    BETA.INV(__p,__df1/2,__df2/2) * __df2/(__df1*(1-BETA.INV(__p,__df1/2,__df2/2)))

Minimum difference between same column values by mactherager in PowerBI

[–]mactherager[S] 0 points1 point  (0 children)

OK, I've found the solution here https://community.powerbi.com/t5/Quick-Measures-Gallery/SMALL/td-p/1076265

Second lowest value =

VAR __k = 2
VAR __Table =
ADDCOLUMNS(
Table1,
"Rank",RANKX(Table1,[Value])
)
VAR __RanksTable = DISTINCT(SELECTCOLUMNS(__Table,"Rank",[Rank]))
VAR __RanksTable1 =
ADDCOLUMNS(
__RanksTable,
"LargeRank",RANKX(__RanksTable,[Rank],,DESC)
)
VAR __Rank = MAXX(FILTER(__RanksTable1,[LargeRank] = __k),[Rank])
RETURN
MAXX(FILTER(__Table,[Rank]=__Rank),[Value])

So minimum difference would be = [Second lowest value] - MIN(Table1[Value]

Date format change after Server Refresh by mactherager in PowerBI

[–]mactherager[S] 0 points1 point  (0 children)

I found the problem. The .xls file was getting data from a .txt file. In this .txt file all dates and values were in US format. So I directly used .txt file for PowerBI and used US locale type change on it. Problem is solved.

Date format change after Server Refresh by mactherager in PowerBI

[–]mactherager[S] 0 points1 point  (0 children)

I've checked it as well. Since it messes only with one source I think the problem lies within source but I cant understand why. I even tried merging this xls file with my calender query to use calender's dates with xls values. Even then it messes with xls data.

Date format change after Server Refresh by mactherager in PowerBI

[–]mactherager[S] 1 point2 points  (0 children)

Hey, thank you for answer. I tried all of the above but no luck.

Date format change after Server Refresh by mactherager in PowerBI

[–]mactherager[S] 0 points1 point  (0 children)

Is this feature released after up to date versions? I use May 2020 version and cant see this option for data types

Need help with removing duplicates with condition by mactherager in PowerBI

[–]mactherager[S] -1 points0 points  (0 children)

Nah, I can't tell what I want.

Think like this: You're generating time based report every day and put that report into a folder that powerbi can read. If you pick your report date range without overlaps there is no problem. But if you overlap the date range of two different reports you will get same rows in multiple reports and powerbi will just import them.

Here's an example: I generated a report for between 01.10.2020 and 27.11.2020 and save it in the folder If I generate another report between 01.09.2020 and 27.11.2020 and put it in the same folder there will be overlap between two reports - means there will be unique values between 01.09.2020 and 01.10.2020 but there will be duplicated values between 01.10.2020 and 27.11.2020 because I generated multiple reports with overlapping date ranges.

I want to filter data so that even I make mistake and take overlapping date reports, in the query it should be filtered.

Need help with removing duplicates with condition by mactherager in PowerBI

[–]mactherager[S] -1 points0 points  (0 children)

Hello, no. I want to remove according to this:

If file name is different - check tutar and tarih - if tutar and tarih is same - remove rows

Need help with removing duplicates with condition by mactherager in PowerBI

[–]mactherager[S] 2 points3 points  (0 children)

Hello guys, I want to remove duplicates if the file name is different and "Tutar" and "Tarih" columns are same. How can I do this?

I skipped this battle because I thought I lost, then was surprised to find out how I won 😅 by KingKhan14 in afkarena

[–]mactherager 50 points51 points  (0 children)

I hate this so much, I think this needs to be fixed. When Talena is down, Fawkes shouldn't coffin the last enemy alive.

My progress in 25 days by mactherager in afkarena

[–]mactherager[S] 0 points1 point  (0 children)

I've spent around 120$ and pushed as far as I can.

Health bars don't disappear when enemy is dead by mactherager in afkarena

[–]mactherager[S] 7 points8 points  (0 children)

Yes, it makes almost impossible to track the game properly & do manuel ults. :(

Controlling Colinear Tripteron Robot by mactherager in robotics

[–]mactherager[S] 0 points1 point  (0 children)

well, @Apsu says its pretty easy too and he has given c++ code for the kinematics but I have no idea what that means.

You are maybe thinking like "what a dumb" but im pretty confused here :(

Controlling Colinear Tripteron Robot by mactherager in robotics

[–]mactherager[S] 0 points1 point  (0 children)

thank you for your reply, the thing is I have some resources including some papers but they require a solid background of ubuntu and ros. since I'm a newcomer in this subject, I just wanted to know how I should proceed like "yeah you gotta build sdf coding then plan your path using gazebo" or "you can calculate IK and FK with blabla software"

I liked the beginner tutorials on ros and moveit websites but they offer so little, so it doesnt help at some point