POWERBI - I want to convert the condition below SQL,

[Anonymous]

Hello guys!

I want to convert the condition below SQL, to DAX. achieve success using measurement with earlier, but I get slow.

WHERE

tab1.cod =2
AND tab1.DATE >='20160101'
AND tab1.DATE <='20190901'
AND tab1.DATEBASE <='20170831'

AND (tab1.DATEBASE1 IS NULL OR tab1.DATEBASE1 >'20170831')

Thank you

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Phil_Seamark]

Hi @Anonymous

Are your data time columns DATE or NUMBER?

Something along these lines might work

Table 2 = FILTER('Tab1' , AND (
                            AND (
                                AND (
                                    'Tab1'[Date] >= DATE(2016,1,1), 
                                    'Tab1'[Date] <= DATE(2019,9,1)
                                    )
                                    ,Tab1[DATEBASE] <= DATE(2017,8,31)
                                ),
                                OR(Tab1[DATEBASE1] = BLANK(),Tab1[DATEBASE1] > DATE(2017,8,31))
                                )
                           )
                          

[Anonymous]

thanks, @Phil_Seamark

my data time columns this DATE.

Returned no value the example, I liked your example.

I will work a little more in it, I try to return success.

thank you again.

[Phil_Seamark]

Here is a slightly different syntax

Table = FILTER('Tab1' , 1 = SWITCH(TRUE() ,
                                   Tab1[COD] = 2 
						&& Tab1[Date] >= DATE(2016,1,1) 
						&& Tab1[Date] <= DATE(2019,1,1)
						&& Tab1[DATEBASE] <= DATE(2017,8,31)
						&& (		Tab1[DATEBASE1] = BLANK() 
								-- OR --
								|| Tab1[DATEBASE1] > DATE(2017,8,31)
							),
						-- THEN -- 
                                    1 ,
						-- ELSE --
                                    0
                                    )
						)