All Dates presented in matrix visual date should start from selected category.

[qadir]

1- I need alll the days to show not just where we have values.

2- I need no Blanks or Nulls in any column, need to display the last available data for each of the category (in my case it is combination of Strat, Ticker and Trader).

You can see i tried joining tables and creating measures/ columns to no use.

Note that, max. drawdown and Net Profit column is all i need to present.

Power BI file can be downloaded from the following link:

pbii

pbii

https://drive.google.com/file/d/1kugJx9Ew478G4gwpzWoIW8BTVeMplnrp/view?usp=sharing

[lbendlin · Accepted solution]

see attached.  Your calculated column could use some optimization.

[qadir]

Thank you @lbendlin, it looks good but dates should started from selected Ticker first value. For example for AMD first value is on 23 july 2007, but matrix visual starts from 4 may 07. It should start from 23 July 2007, and all other Ticker  values should be 0 if there is no value.

[lbendlin]

Feel free to update the measure accordingly.

[qadir]

@lbendlin sorry, I don't understand. I want to presents the date starting from selected category from slicer not from the first  date available in data.

[lbendlin]

 dates should started from selected Ticker first value. 

I don't understand this part.  What is "first value" ? Alphabetically or in the order you selected them?