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 Anonymous 

Please try this

 

Column =
VAR a = 'Table'[str]
VAR b = 'Table'[item]
VAR c = [Date]
VAR _table =
    FILTER (
        'Table',
        'Table'[str] = a
            && [item] = b
            && EOMONTH ( [Date], 0 ) = EOMONTH ( c, 0 )
    )
RETURN
    CALCULATE ( DISTINCTCOUNT ( 'Table'[Date] ), _table )

 

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.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

thanks for supporting , 30 min and still runing 😞