Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
charles_o
Helper I
Helper I

Split value in column with multiple dates

 Hi-

 

New user and of course lots of questions!

 

I currently have data that looks like this-

 

Picture2.jpg

 

The fee is earned 50% on date.1 and 50% on date.2.

 

The data has to be able to graph so that it shows 50% on date.1 and 50% on date.2

 

How can I show this in the data? My first thoughts were something that looks like this below but I do not know how to manipulate into this format.

 

Example.1.jpg

 

Any help would be appreciated!

 

-C

 

 

1 ACCEPTED SOLUTION
SteveCampbell
Memorable Member
Memorable Member

Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .

 

Change the name to New Fee 3.

Enter The following Formula 4:

 

=[Fee]/2

fee.gif

 

 

Now you can delete the original column Fee.

 

Highlight both date colunms. On the Transform tab, click Unpivot Columns.

 

tttt.gif

 

It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.

 

*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!

 



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



View solution in original post

2 REPLIES 2
SteveCampbell
Memorable Member
Memorable Member

Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .

 

Change the name to New Fee 3.

Enter The following Formula 4:

 

=[Fee]/2

fee.gif

 

 

Now you can delete the original column Fee.

 

Highlight both date colunms. On the Transform tab, click Unpivot Columns.

 

tttt.gif

 

It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.

 

*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!

 



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Thanks! Glad to see an active community here.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.