Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Issue on Product Recertification

Hello,  I have an issue. I want to show KRI like this one:  I have one table with column: Product and Yearly Review:  Product Name Yearly review Product 1 Thursday, 24 November 202...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Maybe:

 

Green =
VAR _table =
    SUMMARIZE ( 'Table', 'Table'[Product_Name], 'Table'[Max Date] )
VAR _filter =
    FILTER (
        _table,
        [Max Date] > EOMONTH(TODAY(),-6)
    )
RETURN
    COUNTROWS ( _filter )