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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    thanks a lot , but this formula taking much time of loading then taking much time to refresh data 

     

    • 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 😞