Hi.
I have created a formula that calculates a sum of the last five years sale of a product (quantities).
Now I need to include a filter expression, as I only want to include the transactions that are related to external sales.
The field I want to filter on is Append1[InternalCustomer]. The value I want to keep is '1' (can be 1 or 0).
How do I do this? Where in the formula do I add this expression?
Even before you write a single formula, I'd strongly suggest that you get familiar with time-intelligence in PBI because I can tell you one thing right now: you're not doing it right. The automatic date tables in PBI should never be used if you want to create something useful for others or put it in a production environment. Instead, you should always create a proper Date table. There are just too many reasons to enlarge upon.
Hi. Thanks for the feedback.
I am familiar with time-intelligence.
The formula written was automatically created when I chose 'New quick measure'.
-what is missing is the filter on external sales.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!