Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi-
New user and of course lots of questions!
I currently have data that looks like this-
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.
Any help would be appreciated!
-C
Solved! Go to Solution.
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
Now you can delete the original column Fee.
Highlight both date colunms. On the Transform tab, click Unpivot Columns.
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
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
Now you can delete the original column Fee.
Highlight both date colunms. On the Transform tab, click Unpivot Columns.
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |