Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
admin11
Memorable Member
Memorable Member

I am unable to add Field Amt_on Hand to Table ?

‎11-09-2021 12:09 AM

Hi All

admin11_0-1636445189574.png

My PBI file :-

https://www.dropbox.com/s/ir66t95zqb4s9n5/PBT_V2021_123.pbix?dl=0

 

Paul

Labels:
Message 1 of 3
269 Views
0
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

‎11-09-2021 12:38 AM

@admin11 , Create measure like

Amt_On Hand = SUMX(INVC, INVC[Unit Cost]*INVC[OnHand Qty])


View solution in original post

Message 2 of 3
223 Views
2 REPLIES 2
amitchandak
Super User
Super User

‎11-09-2021 12:38 AM

@admin11 , Create measure like

Amt_On Hand = SUMX(INVC, INVC[Unit Cost]*INVC[OnHand Qty])


Message 2 of 3
224 Views
admin11
Memorable Member
Memorable Member
In response to amitchandak

‎11-09-2021 05:01 AM

Hi All

Can some one explan to me why ?

admin11_0-1636462892528.png

 

Message 3 of 3
194 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All