cancel
Showing results for
Did you mean:
Frequent Visitor

## Measure to give the cumulative week index of a month

I'm not sure how to word this, in short:

In 2018

Week 31 is the first week of August = 1

Week 32 is the second week of August = 2

..

..

Week 35 is the fith week of August = 5

Week 46 is the third week of November =3

Heres a screenshot example:

I'm able to do this on a simple pivot table by having Distinct Count of Week Number as values and summarize it as a running total, Can this be done as a DAX measure instead?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Measure to give the cumulative week index of a month

You may try the following measure.

```Measure =
MAX ( Table1[Week Number] )
- CALCULATE ( MIN ( Table1[Week Number] ), ALLSELECTED ( Table1[Week Number] ) )
+ 1
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team

## Re: Measure to give the cumulative week index of a month

You may try the following measure.

```Measure =
MAX ( Table1[Week Number] )
- CALCULATE ( MIN ( Table1[Week Number] ), ALLSELECTED ( Table1[Week Number] ) )
+ 1
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

## Re: Measure to give the cumulative week index of a month

Works perfectly. thank you very much

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)