cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alecsonline Regular Visitor
Regular Visitor

Stupid question about dates filtering using OR

Hi all, I already know it is a stupid question for you.... but not for me!
As per image below I have a column were a Cancellation is shown, if the item has been cancelled, or it is empty if the item is active.
 
I need to show the situation of the items that were still "active" on a certain date, for example reading the situation on 19/08/2018 I have to tell to PowerBI:
 
count the lines that have "DATACXLREALE" >19/08/2018 OR that have that field empty.
 
So the question is: how should I write the FILTER formula in order to translate the "OR" in DAX formulas?
 
In excel it would be OR(DATACXLREALE>19/08/2018; DATACXLREALE="")
 
Thank you very much in advance, Alessandro
 
1 ACCEPTED SOLUTION

Accepted Solutions
mnayar Established Member
Established Member

Re: Stupid question about dates filtering

@alecsonline its the same way 

 

Result = IF(OR(DATACXLREALE>19/08/2018; DATACXLREALE=""),STATOREALE1)

and then you can distinctcount the result column

 

Here is the DAX UG for that.

https://msdn.microsoft.com/en-us/query-bi/dax/or-function-dax

1 REPLY 1
mnayar Established Member
Established Member

Re: Stupid question about dates filtering

@alecsonline its the same way 

 

Result = IF(OR(DATACXLREALE>19/08/2018; DATACXLREALE=""),STATOREALE1)

and then you can distinctcount the result column

 

Here is the DAX UG for that.

https://msdn.microsoft.com/en-us/query-bi/dax/or-function-dax

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 983 guests
Please welcome our newest community members: