Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have a table with lower and upper limits given for specific products (mix name) and measurements method (propertie). Those limits can change with time, and I'm looking for a DAX measurement to give the last limits, I mean the one from the most recent date indication. I tried LASTNONBLANK function on my lower (TI) and upper (TS) columns but it sorts those numeric column from mini to maxi and give me... the maxi! Any solution to identify the most recent limits from my table?
Thanks,
Solved! Go to Solution.
Hi all! I found a great solution on this last post: https://community.powerbi.com/t5/Desktop/How-can-I-get-the-last-value-of-a-column-in-my-dataset/td-p...
I put the solution in an updated picture, thanks to all answers below!
see you,
Hi all! I found a great solution on this last post: https://community.powerbi.com/t5/Desktop/How-can-I-get-the-last-value-of-a-column-in-my-dataset/td-p...
I put the solution in an updated picture, thanks to all answers below!
see you,
[Last TI] =
if(
HASONEVALUE( T[Mix Name] )
&& HASONEVALUE( T[Propertie] ),
var __rows =
topn(1,
YourTable,
YourTable[Date Fabrication],
DESC
)
return
if(
COUNTROWS( __rows ) = 1,
MAXX(
__rows,
YourTable[TI]
)
)
)
[Last TS] =
if(
HASONEVALUE( T[Mix Name] )
&& HASONEVALUE( T[Propertie] ),
var __rows =
topn(1,
YourTable,
YourTable[Date Fabrication],
DESC
)
return
if(
COUNTROWS( __rows ) = 1,
MAXX(
__rows,
YourTable[TS]
)
)
)
Best
D
Hi @GAETAN63 ,
Create this new column:
Hi @GAETAN63 ,
I am not very clear as to what is your expected outcome. However, you can create a Table.
New Table = Filter ('Table', 'Table'[DateFabrication] = Min('Table'[Data Fabrication])
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |