Forum Discussion
dananjayaprasad
8 years agoHelper I
How to create a sub table (like sub query on SQL) in Power BI Desktop?
Hello, I have an inventory table that contains store names, Product, Skus, On transfer quantity, On hand quantity and on order quantity etc. I am trying to join this table with other, but it will n...
- 8 years ago
Hello,
I was able to achieve this with Summarize function.
Thank you for your help
Zubair_Muhammad
8 years agoCommunity Champion
You can do it with DAX as well by creating a new Calculated Table
Go to Modelling Tab>>> NEW TABLE
New Table= Distinct(TableName)
dananjayaprasad
8 years agoHelper I
Hello,
I was able to achieve this with Summarize function.
Thank you for your help