Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Try going back into PowerQuery and instead of duplicating the column, use a formula to add a new column.
= Table.AddColumn(Custom1, "NewColumnName", each if [Date of Status Change] = "" then [Date of Activity Logged] else [Date of Activity Logged])
I'm not sure where the most recent of the two dates fits in, but you can use List.Max({[Date of Status Change]}&{[Date of Activity Logged]}) to adjust the formula above if I missed something.
Try going back into PowerQuery and instead of duplicating the column, use a formula to add a new column.
= Table.AddColumn(Custom1, "NewColumnName", each if [Date of Status Change] = "" then [Date of Activity Logged] else [Date of Activity Logged])
I'm not sure where the most recent of the two dates fits in, but you can use List.Max({[Date of Status Change]}&{[Date of Activity Logged]}) to adjust the formula above if I missed something.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |