User Profile
BalazsNy
Helper I
Joined 2 years ago
User Widgets
Contributions
Collect distinct items of a row in reverse order in Power Query
Hi All, I would like to collect the distinct values in a row of multiple columns & combine them into 1 cell separated with comma in reverse order, as follows: Could you suggest me a a formula within Power Query to get this result? Thanks in advance.Dynamic index column based on alphabetical order or values of a column (name)
Hi All, I have a report which contains a table including different employee data & I would like to add a dynamic index column based on the alphabetical order of emlpoyee names. However, I would like the index column to be dynamic based on all the selected filters so that it would always start from 1 & not keeping the original (unfiltered) index number. Example: Could you advice any solution / DAX formula to solve this issue? Thanks in advance.Create index column based on criteria (Power Query)
Dear All, I would like to create a kind of index column based on conditions. I have a product ID column and I would like to create an index column in Power Query, which restarts when the product ID changes & the indexing follows the cronological order of date column: Thank in advacne for all tips.Filtering a column by single value which contains multiple options
Hi All, I have a report with 2 tables: The 1st collects Feedbacks of employees within company (imported from a SP list). These feedbacks can have single or multiple categories (in case of multiple selection, categories are separated by comma within the cell). The 2nd is a Category table which contains a single column with each category options individually. I would like to apply a filter based on the values of this column. In practice, I would like to have the option to filter feedbacks selecting categories individually, which would filter out all the feedbacks that contains the selected category, like this: Thanks for any tips in advance.Create relation based on condition
Dear All, I have 2 tables, which I like to connect to each other. First is a manager list table, including manager name / department / start & end date of belonging to that certain department. 2nd table is for feedbacks, with the date (of submission) / Manager name / rate / comment / category & employee ID. I want to create a report with a slicer to be able to filter feedbacks by Departments. Therefore, I need to create a relationship between these tables via Manager name column, but it should also check when the feedback is submitted because a manager can be relocated between the departments by the time (see start / end date). Do you have any idea, how to solve this issue & how relationship between tables should look like. Thank you in advance.
