Forum Discussion
Help with a simple calculation please
Hi mcarangelo ,
Thanks for the reply from Anand24 .
Maybe you can try to convert Direct Query mode to Import mode.
On the status bar bottom right corner, there's a text that reads "Direct Query: On (Click Here To Change)", if you click that and pick Import, your model should start importing.
Note that this is currently a one way trip. i.e., an Import Model cannot be converted back to DirectQuery.
After I established the relationship between the two tables, it worked normally.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Measure would be ideal since you are using fields from 2 separate tables. Even if it was from a single table, measure would be ideal since it doesn't increase data model size.
One important point is that both your tables should have a relationship between them.
Can you attach a screenshot of your model view? Also, it will be great if you have sample data for both the tables.
Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!
Will using 'measure' result in a new column with the calculation result? I attached a screenshot of the model with the fields highlighted in yellow.