User Profile
Jalal_1988
Brass Contributor
Joined 8 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?Solved454Views0likes1CommentCostumer 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.5KViews0likes5CommentsRe: Power Query Add new balance type when Balance = 0, by Customer'
My friend please do not mix them, i just want this letter like explain before and you reach it, about next step (days)، i will doing it, if you reach this letter like example its ok and share the file , Thank you984Views0likes1CommentPower 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.2KViews0likes7CommentsPOWER 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,1.2KViews0likes4Comments
Recent Blog Articles
No content to show