cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
answeriver Regular Visitor
Regular Visitor

Measure or some way achieve result

Hi all,

 

Need your help,

I have report which i make manual (in attachment has all my action), and for it need so much time.

Actualy this is report shows how many clients make purchase of one product and how many times and show it all in runnig total by weeks.

 

Here is file excel https://drive.google.com/file/d/1XnXO-QznB0Zbl_6VwE3AEYgw15ZFrQAW/view?usp=sharing

 

 

Please give any solution of this action in power bi.

2 REPLIES 2
v-danhe-msft Super Contributor
Super Contributor

Re: Measure or some way achieve result

Hi @answeriver,

Could you please offer me more information about how your desired result get:

Count clients with split by count purchase and Running total by weeks
  week 0 week 1 week 2 week 3    
1 204 527 677 747    
2 1 46 109 170    
>=3 0 5 23 47    
  205 578 809 964    

I could not understad the "1" , "2" ,">=3" in your desired table.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
answeriver Regular Visitor
Regular Visitor

Re: Measure or some way achieve result

Hi Daniel,

It is not in my date, i made it for countif.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 291 members 2,898 guests
Please welcome our newest community members: