If an account contains actuals exclude values in visual

[theunissenp]

Hello,

I just starting using Power BI and i'm loving the tool. I have a question about following dataset (monthly load into Power BI)
[TABLE="width: 500"]
<tbody>[TR]
[TD]date[/TD]
[TD]categorie[/TD]
[TD]account[/TD]
[TD]audittrail[/TD]
[TD]data[/TD]
[/TR]
[TR]
[TD]01.01.2019[/TD]
[TD]Q1[/TD]
[TD]Planning[/TD]
[TD]Input[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]01.01.2019[/TD]
[TD]Actuals[/TD]
[TD]Actual[/TD]
[TD]upload[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]01.01.2019[/TD]
[TD]RAF1[/TD]
[TD]Actual[/TD]
[TD]upload[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]01.01.2019[/TD]
[TD]RAF2[/TD]
[TD]Actual[/TD]
[TD]upload[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]02.01.2019[/TD]
[TD]RAF1[/TD]
[TD]Planning[/TD]
[TD]input[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]02.01.2019[/TD]
[TD]RAF2[/TD]
[TD]Actual[/TD]
[TD]upload[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]03.01.2019[/TD]
[TD]RAF2[/TD]
[TD]Planning[/TD]
[TD]input[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



We run a monthly planning cycle. Each new planning cycle is save on a new category. Data from actual months is saved as actual in the category.

In a visual i want to compare my actuals with my planning values. Is it possible to exclude my actual values in de planning categories? If i don't do this i will see these values double... In my actual category and in my planning category. For example the planning category RAF1 contains actuals for the month january and planning for remaining of the year.

For me it's not possible to exclude these values at the source.

Hope you can help me!

Regards,

Paul