User Profile
SatishBadiger
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Finding Average based on multiple criteria
Hi every one, I'm trying to write a formula based on multiple conditions as per stated below. Location Designation Department Rate / Hour IND Data Analyst A 10 IND Data Analyst B 15 US Software Engineer B 25 IND Software Engineer C 12 US Data Analyst A 20 I have a similar table given above. Problem Statement: If there are multiple designations(same designation) per location, then I need the averaged rate based on Location & Designation. For example: For location IND and Designation Data Analyst we have different rates based on department. What I would need is to have rate to be averaged based on Designation and location. For instance here I want (10+15)/2 = 12.5 [Location IND & Designation Data Analyst]. Expected Output: Location Designation Department Rate / Hr IND Data Analyst A 12.5 IND Data Analyst B 12.5 US Software Engineer B 25 IND Software Engineer C 12 US Data Analyst A 20 It would be great if someone could give solutions to DAX, PowerQuery as well if this can be done in those tools.Solved1.9KViews0likes3CommentsIF statement based on multiple columns.
Vendor 1 Vendor 2 Vendor 3 Vendor Master ABC BCD CDE Hi everyone, I'm trying to put up a IF formula for the following scenario. But I'm facing difficulty in getting the proper solution. It would be great if someone would help me to build a proper formula for this one. Problem statement: I have 3 columns for Vendors i.e Vendor 1, Vendor 2, Vendor 3. I want to put up a formula in "Vendor Master" such that IF "Vendor 1" is blank then it should return value from "Vendor 2" in "Master Vendor". IF "Vendor 2" is also blank then it should return value from "Vendor 3". IF "Vendor 3" is blank then it should return a string "No Vendor". It would also be great if someone could tell me how this can be done in Power BI as well. Quick response is highly appreciated. Thanks in advance.46KViews0likes12Comments
Recent Blog Articles
No content to show