cancel
Showing results for
Did you mean:
marijane12 Regular Visitor

Calculate sum if two dates are different

Hi

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?

1 ACCEPTED SOLUTION

Accepted Solutions Community Support Team

Re: Calculate sum if two dates are different

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]))

Best Regards,

Teige

4 REPLIES 4
evandrocunico Member

Re: Calculate sum if two dates are different

Hi, try to create e measure

revenue = calculate(sum(revenue);dateFact <> dateExib)

Regards.

ntaylo06 Regular Visitor

Re: Calculate sum if two dates are different

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?

Highlighted
marijane12 Regular Visitor

Re: Calculate sum if two dates are different

That sintaxe is not possible..-it was the first thing that I did by the way. Anyway I already solve that. Community Support Team

Re: Calculate sum if two dates are different

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]))

Best Regards,

Teige

Announcements Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge. Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform. Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag. Top Kudoed Authors
Users Online
Currently online: 336 members 3,953 guests
Recent signins:
• MRGMSR • CarmenCimpanu • sarvechsamejo • Genevieve • MIchri • TimyBI • adityakommu • lchØSB • timber • Jerremans • Panigrahi • BrandynL914 • robrechts • lbolka01 