Forum Discussion

hosea_chumba's avatar
hosea_chumba
Icon for Helper I rankHelper I
3 years ago

Dax Formula

Take the example below, Please assist to come up with a formula that identifies the common items appearing in all the months.  Date (DD/MM/YYYY) Item 01/08/2022 X 03/08/2022 Y 01/09/...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago
NewMeasure =
CALCULATE (
    COUNTROWS (
        SUMMARIZE (
            ADDCOLUMNS (
                VALUES ( 'Sample'[Date] ),
                "YYMM", FORMAT ( 'Sample'[Date], "YYMM" )
            ),
            [YYMM]
        )
    ),
    ALL ( 'Sample'[Date] )
)
    = CALCULATE (
        COUNTROWS (
            SUMMARIZE (
                ADDCOLUMNS (
                    VALUES ( 'Sample'[Date] ),
                    "YYMM", FORMAT ( 'Sample'[Date], "YYMM" )
                ),
                [YYMM]
            )
        ),
        ALL ( 'Sample' )
    )