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
BhaveshPatel
Community Champion
Community Champion

Converting MDX calculations to DAX ( Inventory ending balance)

‎10-27-2017 07:01 PM

Hi All,

 

I have the below MDX measure to calculate the ending quantity for the Inventory Value in the Inventory Transactions Table.

 

Inventory Ending Quantity:= Sum(PeriodsToDate([Date Hierarchy].[(All)], [Date Hierarchy]), [Inventory Quantity])

 

How can I convert this measure using DAX.

 

Your inputs will be greatly appreciated!

 

Thanks,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Labels:
Message 1 of 3
3,073 Views
0
2 ACCEPTED SOLUTIONS
MattAllington
MVP

‎10-27-2017 08:51 PM

https://www.sqlbi.com/articles/semi-additive-measures-in-dax/


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Message 2 of 3
3,506 Views
BhaveshPatel
Community Champion
Community Champion
In response to MattAllington

‎11-03-2017 08:54 PM

Thanks Matt!  Appreciated.

 

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

Message 3 of 3
3,403 Views
0
2 REPLIES 2
MattAllington
MVP

‎10-27-2017 08:51 PM

https://www.sqlbi.com/articles/semi-additive-measures-in-dax/


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Message 2 of 3
3,507 Views
BhaveshPatel
Community Champion
Community Champion
In response to MattAllington

‎11-03-2017 08:54 PM

Thanks Matt!  Appreciated.

 

 

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Message 3 of 3
3,404 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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