Thank you!! I have been trying to solve this issue for a year and a half. Maybe I am doing something wrong, but renaming the field to blank reverts back to what was originally there.
It was a very helpful video, dude. My search for blogs and videos about this scenario turned up nothing. I am very grateful to you. keep up the great work.
Hello, this is a great video and I feel I am almost there with what I want to do with my matrix, which is the same as shown in your video, only that I want to sort by a date, then by another date. However, I cannot go pass the ALLSELECTED syntax. How can I get further help?
This function is from family of visual level calculations. the sorting works on relation argument, which is a table function of the visual's content. please checkout the WINDOW Functions and understand how it works.
Awesome. Could you please make a video on how to use Rank to sort based on a list of values? Eg rankx -- The third argument of RANKX is useful when the outer -- evaluation requires a different expression than the -- inner one. For example, when ranking an expression over -- a pre-built lookup table DEFINE VAR SalesLevels = SELECTCOLUMNS ( { 6000000, 3000000, 1500000, 750000, 0 }, "@Limit", [Value] ) EVALUATE ADDCOLUMNS ( VALUES ( Product[Brand] ), "Sales Amount", [Sales Amount], "Level", RANKX ( SalesLevels, [@Limit], [Sales Amount] ) ) ORDER BY [Level] ASC 2. How to do approximate match lookup in powerbi
Can't say when it got added, i found this while authoring another DAX expression with RANKX(). Surprisingly there is no any documentation or other information available about this function at present. but the approach is similar to existing window functions.
Hello power bi helpline. I had a requirement, if possible can you do this as a video. I had IoT data for 1hr data. I am using direct query mode. In xaixs i am using time stamp hh:mm:ss format. So when ever new data comes the xaxis need to be dynamic. Example, in xaxis data starts from 1:24:10 and ends with 1:26:30. When the new data comes it should be 1:25:15 and end is 1:27:46. Xaixs need to be dynamic with 2min interval. Xaxis is need to be moving. How can we achieve this?
It is suggested to use Streaming dataset for IoT data input. i have posted videos on streaming datasets. or if you want to stream with direct query, you need to enable auto page refresh for every second/ or use change detection. A video is also available for this.
Thank you!! I have been trying to solve this issue for a year and a half. Maybe I am doing something wrong, but renaming the field to blank reverts back to what was originally there.
It was a very helpful video, dude. My search for blogs and videos about this scenario turned up nothing. I am very grateful to you. keep up the great work.
Glad to know it was helpful. thanks for the feedback.
Hello, this is a great video and I feel I am almost there with what I want to do with my matrix, which is the same as shown in your video, only that I want to sort by a date, then by another date. However, I cannot go pass the ALLSELECTED syntax. How can I get further help?
This function is from family of visual level calculations. the sorting works on relation argument, which is a table function of the visual's content. please checkout the WINDOW Functions and understand how it works.
Awesome. Could you please make a video on how to use Rank to sort based on a list of values? Eg rankx -- The third argument of RANKX is useful when the outer
-- evaluation requires a different expression than the
-- inner one. For example, when ranking an expression over
-- a pre-built lookup table
DEFINE
VAR SalesLevels =
SELECTCOLUMNS ( { 6000000, 3000000, 1500000, 750000, 0 }, "@Limit", [Value] )
EVALUATE
ADDCOLUMNS (
VALUES ( Product[Brand] ),
"Sales Amount", [Sales Amount],
"Level", RANKX ( SalesLevels, [@Limit], [Sales Amount] )
)
ORDER BY [Level] ASC
2. How to do approximate match lookup in powerbi
Awesome solution using #RANK() function? Since when this function exists?
Can't say when it got added, i found this while authoring another DAX expression with RANKX().
Surprisingly there is no any documentation or other information available about this function at present. but the approach is similar to existing window functions.
Hello power bi helpline.
I had a requirement, if possible can you do this as a video. I had IoT data for 1hr data. I am using direct query mode. In xaixs i am using time stamp hh:mm:ss format. So when ever new data comes the xaxis need to be dynamic. Example, in xaxis data starts from 1:24:10 and ends with 1:26:30. When the new data comes it should be 1:25:15 and end is 1:27:46. Xaixs need to be dynamic with 2min interval. Xaxis is need to be moving. How can we achieve this?
It is suggested to use Streaming dataset for IoT data input. i have posted videos on streaming datasets.
or if you want to stream with direct query, you need to enable auto page refresh for every second/ or use change detection. A video is also available for this.
Thanks a Ton!!!!. Very useful video
Glad you liked it
is ABC analysis better to be done with Rank or windows function?
I have posted a video on ABC analysis using Window Functions, You can check that out. These functions are really amazing.
Nice one! Thanks!
Nice channel !
Thanks for the visit
very usefull thank you.
Glad to know it was helpful. thanks for the feedback.
ı liked it.thanks
Glad to hear that