User Profile
Kavitha10
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Renaming column headers in a table
Hi, I would like to know how to rename column names dynamically in my case scenario. I have a table with column headers as CY-2,CY-1,CY,CY+1,CY+2 along with many other columns If CY is 2020, then I need to rename the column names as when CY is 2021, then they should get renamed as Please, anyone has an idea ? Thanks in advance.Dynamic column calculation based on user selection
Hi All, I would like to know if we can dynamically calculate column values in powerbi based on user selection For example, If user selects 1 from the selection filter, then my Result column should calculate as 'Col_A * 1' whereas if user selects 0 from the selection filter, then my Result column should calculate as 'Col_A * 0' Thanks in advance!Dynamic column creation
Hi All, Is there any way to dynamically create calculated columns for each of the values stored in the list/table. I have a list/table with values A,B,C, I need to create columns - A with filter on A, B with filter on B and so on dynamically. Any help is really appreciated. Thanks in advance! Edited: Please refer to the example below for further clarification on my query. For example, let’s consider If Date in Table-1 falls between Start Date and End Date of Table-2, then take sum of Amount from Table-1. So, I need to dynamically create columns for each of the distinct values of Company Name from Table-1 (as shown in Result of Table-2 to be) using M query.
