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 would like some help
How do I search for a value and a certain date?
I need to do something similar to a SQL SELECT MAX.
What function can be used?
Thank you,
LRFeltz
Solved! Go to Solution.
Hi @LRFeltz,
Suppose there is a table containing three columns (Column1,Column2,Column3), now you need to get the max value in Column2 and its corresponding date.
In this scenario, you can use SelectColumns function to return the two columns you need first.
NewTable=SelectColumns('TableName',"Date",'TableName'[Column1],"Value",'TableName'[Column2])
Then use Max function to get the max value based on above table.
NewTable2=CalculateTable('NewTable',FILTER('NewTable','NewTable'[Date]=MAX('NewTable'[Date])))
Then, you can drag a table visual to display the data records in NewTable2.
If I have something misunderstood, please share your sample data.
Thanks,
Yuliana Gu
Hi @LRFeltz,
Suppose there is a table containing three columns (Column1,Column2,Column3), now you need to get the max value in Column2 and its corresponding date.
In this scenario, you can use SelectColumns function to return the two columns you need first.
NewTable=SelectColumns('TableName',"Date",'TableName'[Column1],"Value",'TableName'[Column2])
Then use Max function to get the max value based on above table.
NewTable2=CalculateTable('NewTable',FILTER('NewTable','NewTable'[Date]=MAX('NewTable'[Date])))
Then, you can drag a table visual to display the data records in NewTable2.
If I have something misunderstood, please share your sample data.
Thanks,
Yuliana Gu
It worked.
thank you.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |