Forum Discussion

Vinit's avatar
Vinit
Frequent Visitor
3 years ago
Solved

DAX Divide Formula

Hi, I want DAX formula for Divide, it likes, Measure = No. of product / (no. of days between two dates - 1 - No. of Sundays in selected period)   Measure = COUNT('Production of the day'[products...
DAX Divide Formula
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi

    Just count the number of days without sundays, it is easier

     

    Working Days = 
CALCULATE(
    COUNTROWS('Date Table'), 
    FILTER('Date Table', 
        Not WEEKDAY('Date Table'[Date],2) in {7}
    )
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

 

Please give some samples of your data. Thks

  • Vinit's avatar
    Vinit
    Frequent Visitor
    3 years ago

    In the above image,

    In Date, Both Date (01/09/2022) & (30/09/2022) are coming from same column

    i.e. 'Production of the day'[actualendtime]

    Below,     J961     SH1599     C18      BL5

                  36.962    61.500     0.692    0.192

    here for e.g. ,

    J - Jeans(it is a product) , 961 - Total product count between 01/09/2022 & 30/09/2022, 

    36.961 = 961/(30-4) i.e. 30- total selected days & 4 - no. of sundays between selected days(01/09/2022)&(30/09/2022).

     

    here is contect , 

    Production of the day'[productshortname] = J

    COUNT('Production of the day'[productshortname]) = 961

    VALUES ( 'Production of the day'[actualendtime] ) = 30

    no. of sundays i.e. 01/09/2022 & 30/09/2022 = 4

    ( how should i write DAX for no. of Sundays only between any selected date)

     

    So I required DAX formula for 36.961 i.e 961/(30-4) 

    hope you get it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi

      Just count the number of days without sundays, it is easier

       

      Working Days = 
CALCULATE(
    COUNTROWS('Date Table'), 
    FILTER('Date Table', 
        Not WEEKDAY('Date Table'[Date],2) in {7}
    )
)