Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
fever003
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
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
Ashish_Mathur
Super User
Super User

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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. 

Hi,

 

If my solution helps, please mark it as Answer.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Sort of. Will mark as solution.

fever003
Frequent Visitor

Could anyone help me please?

Well i guess nobody could help me with this then

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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