Forum Discussion
Data Representation
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
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.
- Eric_Zhang9 years agoMicrosoft Employee
lailailaieric wrote:
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.
What is the calculation? Maybe you can create a third measure = measure1+measure2.
I'm not still clear about your situation, maybe you can upload a pbix with sample data and post the expected output.