Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    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])
binner's avatar
binner
Regular Visitor
8 years ago

For simplicity's sake you can create a measure using the LOOKUPVALUE function:

 

Measure = LOOKUPVALUE(Table[Lookup field],Table[Date],MAX(Table[Date]))