Creating custom column based on other column value
Creating new Custom Column based on other column value. In this case checking if other column is empty or not using the length of the value. In the Custom column add the code: each if Text.Length([subrule_id]) > 0 then 1 else 0 in the table colum you will see some different syntax as below: Table.AddColumn(#"Changed Type", "subrule_id_flg", each if Text.Length([subrule_id]) > 0 then 1 else 0) Hope this can help anyone who is working on the similar problem. Thanks
Multiple Columns, One Table, Multiple Vales from each column needed in new column
I have a wild request from one of my teams. They stupidly have an Excel that they populate each month that's based on Account Managers - but all those Account Managers live in different fields in the CRM - I think 7 in total. Before I go back and shout at them for being stupid and ask them to tidy their data up, I want to know if it's even possible in Power Query to combine multiple values from each of the columns, into one column? I gave it a go using a custom column e. [regional director]&" "&[managing director]&" "&[sales director] etc, but it just came back with nulls as I'm presuming as there is multiple values in each of those columns, it can't deal with it. But as ever, I know with Power Query, there will always be a way to do this. Essentially, within my new columns, I want all the Directors that are listed in each of the 7 fields/columns, to be listed, regardless of whether that are accounts with 5 Managers, 4, 3 etc. Actually, even as I type that out - I can't have a column with all of those can I? The end goal would then be to use a visual level filter to let me choose which Directors appear in the visual. Anyone else come across a similar problem? Thanks in advance
Dax Column - Copy Date from a defined column and IF blank... copy date from another defined column
Hi all, My first time posting and I'm new to PBI, so apologies if this is a little unorganized. Below is a snapshot of my data table. The outcome I am looking for is to show in the "Date of Activity Logged - Copy" Column the "Date of Status Change" date for this row and IF this is blank... to show the "Date of Activity Logged" date for the same row within the "Date of Activity Logged - Copy" also. Unfortunately the source of this dataset splits these two dates into different cells, when the preferred outcome is that only the most recent date of the two is shown in a column... if that is a different way to view the issue? Any help on this is appreciated. Many thanks Matt
Comparison of column value to average of column total
Hello Community, Excuse the fact that I might be posting this with a possible solution floating around the community, I've tried to use different solutions found around the community but none seem to fully cover the requirement I have, either that or I may not be approaching this issue correctly. In any case, I have a table that represents every project that is ongoing or completed, alongside that is a column that represents the number of active days per project (in the project's lifecycle is a total number of active days for that project as well as a number of days where the project was idle/on-hold). From this column I'd like to calculate the total average based on selected values filtered by slicers and compare whether the project's number of active days is greater or less than the generated average. Below is an example of what I'm trying to achieve, the representation might be lackluster but: Input: Output would be: If filtered for market 'A' In this case since the selected filter is for Market 'A' the avg is computed based on the values extracted for this filter and generates each project's status based on the comparison between that average and the project's # of Active Days, I would like to be able to implement this either based on a Market slicer selection or Customer slicer selection. I've pretty much managed to nail the logic for the status and comparison and at one point event the average but strictly on a market basis but can't seem to find the right way to compute the average to adjust based on selected market or customer slicer. Any help or suggested solutions are greatly appreciated. Best, Sam
Conditional replace and custom column.
Hello good people, I need to create DAX formula to replace sentences with random information into specific words. For example, it will look for words like dehy, hypo, impair from sentences in the strings in a specific column and replace the whole sentence as "injury" into a cutom column. I know that it can be done from custom column option. But I am not sure about the DAX code to do this.
