cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## 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'[productshortname]) / (VALUES ( 'Production of the day'[actualendtime] )- 1 - no. of sundays)

how should i write Correct fromula for this.

Here is context of each term,

No. of product = COUNT('Production of the day'[productshortname]),

no. of days between two dates =  (VALUES ( 'Production of the day'[actualendtime] ),

1 = totals selected no. of days minus 1 day (it is value not text),

No. of Sundays in selected period = no. of sundays( how should i write DAX for no. of Sundays only)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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}
)
)``````
3 REPLIES 3
Anonymous
Not applicable

Hi,

Frequent Visitor

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
Not applicable

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}
)
)``````

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors