Need help with DAX formula to only show values in the future

[MO_123]

Hello,

I am working with a matrix table where users only want to see forecast values GT 0 in the future however my tbl pulls demand & forecast units by period.  Can someone help with some DAX to show forecast for future values while retaining demand values in the past. So in other words per below we should only see Demand for each period and in future forecast.

Matrix tbl: 

201901   201901     201902     201902

Demand  Forecast   Demand  Forecast

20                             15           

Thanks in advance,

monica.osetkowski@thermofisher.com

[v-rzhou-msft]

Hi @MO_123 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@MO_123 The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[Greg_Deckler]

@MO_123 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.

[MO_123]

Thanks for the quick response.  New to this so let me see if I can share the examples.  The current scenario forecast is displaying null values for history (as it should since we do not retain forecast in the past).  If I try to remove or filter them out demand is also excluded.  Users only want to see the forecast column in the table where there are values.  Hope this is more clear.  

Current Scenario:

201901	201901	201902	201902
Demand	Forecast	Demand	Forecast
20		15

Desired Outcome:

201901	201902	202010	202011
Demand	Demand	Forecast	Forecast
20	15	30	30

Thanks again,
Monica

[v-rzhou-msft · Accepted solution]

Hi @MO_123 

Due to I don't know your data model, I build a sample to have a test.

Build a Matrix as below.

You can change your data model like the table above and then you can achieve your goal.

You can download the pbix file from this link:  Need help with DAX formula to only show values in the future

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.