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.
Frequent Visitor

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

Works perfectly. thank you very much

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 209 members 2,557 guests
Recent signins: