DAX function to sum values of 2 columns with same calendar

[Manoli]

Dear all

I am very new on Power BI

I need to make a report which gaves me a projected stock

For example, I have an actual stock for Month M

In order to get the projection of Month 2 I will need to take the Month M stock, take off the consumptions of M and add the scheduled recept of Month M. 

First, I wanted to create a metric which will sum two diferent scheduled receipts. In order to have by month all my schedulded receipt. I have two input : my orders and my scheduled receeipt not released yet.

I have the reception date of my order when I take my field "delivery date"

I havethe release date of my scheduld recepeit when I take my field "planned release date"

All these dates have the same logic, by year, trimester, month and day.

When I do my metric SUM (V_FCT-table xx [scheduled recepeit quantity] + COUNTA (V_FCT xx [Ordered quantity]

It's working, but of course when I want to do my matrix table, by chosing "delivery date" or "planned release date", the quantity showing is good for only one category and not for the other one.. This is the same date logic, how can I merge these two datas and keep only one category of date that I will select when I will use my metric ?

In attached a printshot of my two tables

Thank you so much

1

[Anonymous]

Hello,

Thank you for your answer, it helped me !

[Greg_Deckler · Accepted solution]

@Manoli So this issue is sometimes solved by having multiple date dimensions. Or, you can use multiple relationships and use USERELATIONSHIP. Finally, you can form the relationship in the measure by using ALL or ALLSELECTED to override the filter context and then filter back down to what you want. To be more specific, would need sample data, etc.

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.