Forum Discussion

jeronimo2334's avatar
jeronimo2334
Helper III
5 years ago

Dax Table Filterting

Hello all,   I have a table like so:   I have connected it to a date table all the start and thru columns on the right side are connecting to the Date column on the left:   And I crea...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

Could you kindly show the expected result in a few rows of column H of the table1.xlsx file?  

jeronimo2334's avatar
jeronimo2334
Helper III
5 years ago

Hi,  I forgot to include something important in tables 1 & 2, the ID column.  Table 1 and Table 2 should match on the ID column.

I added Table 3 which is what the expected result should be.

https://www.dropbox.com/sh/lgdxefabz139xsh/AADnr0RfSe-4YTWMs9Xjj34Ga?dl=0

Just for reference, if this was to be done via MySQL, the 'where' parameters would look like this

set @d = "2018-01-12";#example of posted

...WHERE cr.effectiveDateStart <= @d and (cr.effectiveDateThru is null or cr.effectiveDateThru >= @d) and c_r.effectiveDateStart <= @d and (c_r.effectiveDateThru is null or c_r.effectiveDateThru >= @d) and opi.effectiveDateStart <= @d and (opi.effectiveDateThru is null or opi.effectiveDateThru >= @d) and pi.effectiveDateStart <= @d and (pi.effectiveDateThru is null or pi.effectiveDateThru >= @d) and ui.effectiveDateStart <= @d and (ui.effectiveDateThru is null or ui.effectiveDateThru >= @d)