How to add Target column

[PBI_newuser]

Hi,

I have table as below, how to add the target % and days before the Year-Month for each product?

For example:

Measure	Target	2019-11	2019-12	2020-01
Confirmed Install to Actual Training	85%	0.0%	33.3%	93.3%
A	85%		100.0%
B	85%			100.0%
F	85%
AveConfirmed Install to Actual Training
A	3 days	12	10	2
B	15 days		8
F	24 days			21

[Anonymous]

Hi @PBI_newuser 

Could you provide me a sample like yours? This may make it easier for me to understand your data model and values in it.

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. 

[amitchandak]

@PBI_newuser , you are raw data and the expected output is not clear.

But seem like you need a hybrid display. Which is not avaiable.

Workaround

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc