If an account contains actuals exclude values in visual

theunissenp

New Member
Joined
Feb 28, 2019
Messages
2
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)
datecategorieaccountaudittraildata
01.01.2019Q1PlanningInput15
01.01.2019ActualsActualupload20
01.01.2019RAF1Actualupload10
01.01.2019RAF2Actualupload10
02.01.2019RAF1Planninginput15
02.01.2019RAF2Actualupload12
03.01.2019RAF2Planninginput15

<tbody>
</tbody>



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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,102,448
Messages
5,486,964
Members
407,574
Latest member
Greso

This Week's Hot Topics

Top