Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Counts in Specific conditions

dear All, i need Dax Formula to add new column in table with following condition number of days in same month included item in store, example : item 1111 in Store A repeated in 1-2-3 Oct so repeated...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi,

Thanks for the solution Greg_Deckler  offered, and i want to offer some more information for user to refer to.

hello Anonymous , you can create the following calculated column.

Column =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Date] ),
    FILTER (
        'Table',
        'Table'[str] = EARLIER ( 'Table'[str] )
            && [item] = EARLIER ( 'Table'[item] )
            && EOMONTH ( [Date], 0 ) = EOMONTH ( EARLIER ( 'Table'[Date] ), 0 )
    )
)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.