Forum Discussion
Helper IISimple fields are showing in Data model as aggregation filed
Hi shabirAhmad it could be that your columns are mainly number data types. During transformation in PowerQuery you can change it and apply wanted format.
Hello shabirAhmad ,
in order to use them as sum or subtract they should be with a numeric type and should show the aggregate sign which is normal.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Helper IIThanks for both of you for valauble replies, actually, i want to find out "On Hand" Quantity of item so i wrote the below DAX in measure but not working is it write?
On Hand Qty = SUM(POWERBIUEINVENTONHANDITEM[POSTEDQTY]) + SUM(POWERBIUEINVENTONHANDITEM[RECEIVED]) - SUM(POWERBIUEINVENTONHANDITEM[DEDUCTED] )+ SUM(POWERBIUEINVENTONHANDITEM[REGISTERED]) - SUM(POWERBIUEINVENTONHANDITEM[PICKED])
View from SQL Server Name is POWERBIUEINVENTONHANDITEM and remaining are fields [fields]
Best Regards,
Shabir Ahmad
Community ChampionHi shabirAhmad if you are using data from SQL maybe you should check link https://learn.microsoft.com/en-us/power-query/query-folding-examples
- shabirAhmad
some_bih ,
Thanks for your reply, i am using views from Dynamics ERP , and these views are shown as views in SQL SERVER No check the below item 00000010 quanity on hand 289
The same item in Power BI show 610 that's strange
Best Regards,
Shabir Ahmad
- Idrissshatila
Super User
hello shabirAhmad ,
can yoiu check it in power query to see if its readung the data correctly and from where is the issue coming from.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡- shabirAhmad
Thanks for your reply and support please check here it showing all transaction data even showing the figure which i need 289 check the below image of power Query. If we plus these values it gives 610 which is in coming in power bi report
Best Regards,
Shabir Ahmad