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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

Anonymous Try:

Column = 
    VAR __Item = [Item]
    VAR __MonthYear = YEAR( 'Table'[Date] ) * 100 + MONTH( 'Table'[Date] )
    VAR __Table = ADDCOLUMNS( 'Table', "__MonthYear", YEAR( [Date] ) * 100 + MONTH( [Date] ) )
    VAR __Table1 = SUMMARIZE( FILTER( __Table, [__MonthYear] = [__MonthYear] && [Item] = __Item ), [Item], [Date] )
    VAR __Result = COUNTROWS( __Table1 )
RETURN
    __Result
Anonymous's avatar
Anonymous
Not applicable
1 year ago

dear , its not working then you didnt mention store becuase it is related to date and store and item