User Profile
Jalal_1988
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Don't change slicer in power pivot
Dear friends I have problem in power pivot , i want when we click on the slice the % profite fix and don´t change when we click on the pure invoice slicer, in other i want when we click on the slicer the % profit dont change, show the numbrs lie before cliking How i can doing this?Solved410Views0likes1CommentCostumer payments velocity in one day in percntage
I have an invoice for a customer to whom we sell on credit. In one column, the amount paid by the customer is specified, and in another column, the sales amount is specified. In one column, there is the customer's Balance. This customer has made purchases from us three times, and the balance is now zero. I want to calculate the customer's payment speed for each transaction (it means i want to calculate the velocity of payments for this costumer, in other how much is the average of payments of this costumer in Percentage), meaning I want to know on average, what percentage of their payments amount they have paid during these three purchases in one day how much in percentage? "Point: for this aim we should extract the days which the costumer balance is not zero then ..." Thank you.Solved1.5KViews0likes5CommentsPower Query Add new balance type when Balance = 0, by Customer'
Hello my Friends I have problem in power query thank you for your help I want to create a column like L power query, when the balance reach to zero change the letter and also when the costumer change also letter changed, also sorted by date, this file is balance statements for two costumers, thank youSolved1.1KViews0likes7CommentsPOWER BI CHALLENGE
Hello My Friends Kindly in attached Zip file you can find two Excel and power bi files, Is there any one to move the Pivot table formula in excel file to Power Bi ?, I have done some steps in power Bi , Please notice that in Excel file we extract statements for one costumer, but in Power BI we want for all costumers, Thank you my friends,1KViews0likes4Comments
Groups
Recent Blog Articles
No content to show