Hi, In the end - I have managed it differently. Basically, in my Dataset 2 I have set the 'Counter' column as text. Then during dataflow adding a new column works as expected. In the resulting dataset I'm changing the 'Counter' column back into number. Not super elegant but it works for me. Hope it helps, Pawel.

Nice idea! When You mean to add it as a new column You mean during the Data Flow process right? Agreed, definitely not a final solution but I'll test it. Thanks.

Hi, Not exactly The issues is that I have only one column named: Task Category. Then, I have different values for it.... e.g. Standby, Overtime, Urgent, etc. So, what I'm looking for is how to sort the data in that column: What I would like is to have Standby | Urgent | Overtime Regards, Pawel.

Any ideas why this isn't working? Just trying to bring it to top of the queue in case anyone knows it but missed it Best regards, Pawel.

Cool - that's exactly what I was looking for! Thanks!

Thanks Mark, Are You able to save a Data Set with a different name or are You referring to Data Flows? - because I cannot find a way to save a Data Set with a different name! In any case - it's an issue. If I want to change the Data Set in a Data Flow - I have to re-create all processing done afterwards Regards, Pawel.

Hi Christian, Well, the above also results in a Attribute (not a measure) and let me explain my issue in more detail. I have Week Ending date in my columns which I'm displaying as Months, Weeks, etc. So, I need to calculate the number of weeks between a fixed start date and the given week in my Week End Date column. The…

Actually - maybe this small picture will help explain better: As You can see in 3rd line the Count of Weeks is only 3 (because user didn't report time for 2 weeks) so his Utilization (Hrs/Count of Weeks) is Wrong. With weeks 2 - I'm playing to find a way so that e.g. for June - no matter how many weeks are reported by whom…

Hi Gabby, Thanks for Your explanation. In this case, is there a way to add nulls during data flow? In am joining all my data from one place with another excel that has a listing all week end dates: So, I end up with some empty rows with only the week end date in the last column. Not sure if these are nulls in this case or…

Thanks, this works!