I have a revenue which has two dates: dateExib and dateFact I want to sum(revenue) only if dateFact is different from dateExib. Do you know how can I do it?
Go to Solution.
Hi @marijane12 ,
Assume we have a table like below:
Then we can use the following DAX query:
revenuesum = CALCULATE(SUM(Table1[revenue]),FILTER(ALL(Table1),Table1[dateExib] <> Table1[dateFact]))
Hi, try to create e measure
revenue = calculate(sum(revenue);dateFact <> dateExib)
The logic for "only if dateFact is different from dateExib" is:
IF('Table'[dateFact] <> 'Table'[dateExib], "Do something if true", "Do something if false")
But the second and third arguements depend on where you are putting the logic. Is this going to be a column in a table? Or will it be a measure?
Another way to ask this question is when you say "sum(revenue)" what revenue(s) do you mean?
That sintaxe is not possible..-it was the first thing that I did by the way. Anyway I already solve that.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!