Forum Discussion

ryand009's avatar
ryand009
Frequent Visitor
3 years ago

Dax Outer Join

Hello   I’m building a PBI report to look at SSRS report usage. I need a measure that returns the usage of reports created in the last six months. Two tables used in the measure   Catalog table -...
DAX
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

ryand009 Maybe: 

EVALUATE
ROW (
    "b",
        CALCULATE (
            COUNTROWS ( ExecutionLogStorage ),
            'Catalog'[CreationDate]
                >= DATE ( YEAR ( NOW () ), MONTH ( NOW () ) - 6, DAY ( NOW () ) )
        ) + 0
)