cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fever003 Frequent Visitor
Frequent Visitor

Count of first time this week

Hi

I have a data showing accounts, week, and status of accounts.

1.png

 

This is the expected output. I amtrying to create a measure for the right most column below. Appreaciate your help!

2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count of first time this week

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

6 REPLIES 6
fever003 Frequent Visitor
Frequent Visitor

Re: Count of first time this week

Could anyone help me please?

fever003 Frequent Visitor
Frequent Visitor

Re: Count of first time this week

Well i guess nobody could help me with this then

Super User
Super User

Re: Count of first time this week

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

fever003 Frequent Visitor
Frequent Visitor

Re: Count of first time this week

Hello, thank you for helping me out. I am just trying to understand the measure you have created because I am trying to apply it to the data which has a similar structure as example I shared.

I have tried RANKX and almost getting there, but how saw that you used SUMMARIZE. 

Super User
Super User

Re: Count of first time this week

Hi,

 

If my solution helps, please mark it as Answer.

fever003 Frequent Visitor
Frequent Visitor

Re: Count of first time this week

Sort of. Will mark as solution.