Forum Discussion
How do I visualize only the latest date?
I have a table that will be updated weekly with the latest numbers (told sold, revenue, commission). It's updated weekly based on weeks out from the deadline. I would love to create guages, cards, o...
if your table is called [MyTable] you could create this as a table for your gauges
Hit the "New Table" button on the Modeling tab of the ribbon
Filter Table = FILTER( CROSSJOIN( 'MyTable', SUMMARIZE( FILTER('MyTable','MyTable'[Total Sold] >0), "Latest week", max('MyTable'[Weeks Out Date]) ) ), [Latest week]='MyTable'[Weeks Out Date])
if your table is called [MyTable] you could create this as a table for your gauges
Hit the "New Table" button on the Modeling tab of the ribbon
Filter Table = FILTER(
CROSSJOIN(
'MyTable',
SUMMARIZE(
FILTER('MyTable','MyTable'[Total Sold] >0),
"Latest week",
max('MyTable'[Weeks Out Date])
)
),
[Latest week]='MyTable'[Weeks Out Date])Perfect. This seems to have done exactly what I was hoping. Thank you!
This is my first venture into the "New Table" (or even the "new column") modeling. Do you recommend any tutorials on use cases or how to use?