Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I have 2 different date and calculate week numbers for these. (In second image)
I want to show last 3 values of every column. (In first image)
Thanks for your support
Solved! Go to Solution.
Hi @ekarakasli
Sorry for my mistake, the measure of “rank” should be corrected as below:
Measure =
var _rank=SUM('Table'[value])
var ran = RANKX(ALLSELECTED('Table'[Column]),CALCULATE(Max('Table'[Column])),,ASC,Dense)
var a = IF(_rank <>BLANK(),ran,BLANK())
return a
The function I marked bold should be modified to “Max”, not “Sum”.
And you will finally see as below:
Sorry again and hope this time would help.
Best Regards,
Kelly
Hi, I would like to create a table with week columns where I have to show the last 4 values of every column, the values are comming from a measure. How can I do that, please? I used your two measures posted here in my solution and visaulize the data in a matrix. The matrix show me now the values in "waterfall" form, but I need to see the last 4 values in 4 rows to be abble to make row totals like average, min, max, etc. Can you share the result, please? The link for .pbix in this post is not working for me.
Hi @ekarakasli ,
What you need is to create 2 measures:
1. set a rank according to the first column:
Measure =
var _rank=SUM('Table'[value])
var ran = RANKX(ALLSELECTED('Table'[Column]),CALCULATE(SUM('Table'[Column])),,ASC,Dense)
var a = IF(_rank <>BLANK(),ran,BLANK())
return a
2. get the last 3 values according to the rank.
Measure 2 =
var a =MAXX(ALLSELECTED('Table'[Column]),[Measure])
var b = a-2
return
IF([Measure] >=b && [Measure]<=a,SUM('Table'[value]),BLANK())
With the 2 measures, you will see as below:
You can find the related .pbix file using the following URL: https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/EZzHKKuBdSpEp5FrMY8lc...
Hope it would help.
Best Regards,
Kelly
Hi, I can not reach the file. Can you share some result pictures, please?
Thanks for your answer.
When i checked your answer i saw a problem.
This measure don't give same values every colum.
When i try your mesure on my date, I have some situation again.
Do you have another alternative or solution for this ?
Hi @ekarakasli
Sorry for my mistake, the measure of “rank” should be corrected as below:
Measure =
var _rank=SUM('Table'[value])
var ran = RANKX(ALLSELECTED('Table'[Column]),CALCULATE(Max('Table'[Column])),,ASC,Dense)
var a = IF(_rank <>BLANK(),ran,BLANK())
return a
The function I marked bold should be modified to “Max”, not “Sum”.
And you will finally see as below:
Sorry again and hope this time would help.
Best Regards,
Kelly
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |