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])
Dan80's avatar
Dan80
Icon for Helper II rankHelper II
9 years ago
Import data using power query. Filter out null values in total sales column. Add custom column to find minimum value of weeks out column List.Min(#"your previous step" ["weeks out"]). Add another custom column using if weeks out=min weeks out then "keep" else "delete". Filter out the deletes and boom. Latest data that will automatically change with new data