Forum Discussion
Measures Table Blocking Queries. Cannot convert value "" to type Table.
AmBigsPBI,
Interesting. I don't know if this is the "right" way either but how I usually create my measure table is from the below, then deleting the single, empty column I created.
Maybe you find that less convoluted this way, maybe not. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
As I said, completely blank. I did not create the table in the power query as you are. I used the New Table button on the modeling tab in desktop as seen below. I left the formula blank and started adding measures to the table. I'm now guessing that this isn't the proper way to create a measures table and the column error is possibly due to it expecting a physical column.
Memorable MemberAmBigsPBI,
Interesting. I don't know if this is the "right" way either but how I usually create my measure table is from the below, then deleting the single, empty column I created.
Maybe you find that less convoluted this way, maybe not. 😄
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Well if it has never given you the error I am getting, I'd say that way is more right than my way. I will change to that. Thanks!