Forum Discussion
Data Representation
Sorry Phil,
Do you mind showing it once to me, step by step how you can type in the formula?
Because I am unable to locate the place to do so.
Thank you so much for your help.
REally appreciating you helping me
Sure, First of all make sure your table is highlighted, Then from the modeling table, click the "New Measure" button
Then 2) enter the forumla I posted above in step 2 ) but change the name of Table2 to be the same name as your table
- lailailaieric9 years agoRegular Visitor
Hi Phil_Seamark
Thank you for your helpful teaching.
Now that I have the new measures, would it be possible if I can do the same thing? Cause when I tried to add another measure, seems like they dont have this new measures as columns for me to pick from.
Thank you so much.
- Eric_Zhang9 years agoMicrosoft Employee
lailailaieric wrote:
Hi Phil_Seamark
Thank you for your helpful teaching.
Now that I have the new measures, would it be possible if I can do the same thing? Cause when I tried to add another measure, seems like they dont have this new measures as columns for me to pick from.
Thank you so much.
Not sure what exactly you're trying to do, could you be more specific?
- lailailaieric9 years agoRegular Visitor
Sorry for the confusion.
Measure 1 and 2 came from different calculations in the excel.
Therefore, I would like to ask is there a way to do calculations for measure 1 and 2 together?
I was not able to locate "Measures 1 or 2" when I was starting a new column.
Hope this clears the confusion.