condition between 2 dates

[c_pannese]

Hi,

how can i create a list of dates in a straight table? I'm trying with :

if(dt_scad_art>=min(Data_confronto2) and dt_scad_art<=max(Data_confronto2),dt_scad_art)

dt_scad_art is in my fact table

Data_confronto2 is in a no linked table.

but it doesn't work as dimension and  doesn't work as measure.

thank you