Dax Formula for only Dates with values

[hnk1]

Hi everyone

i have two tables, a date table from 1.1.2019 - 31.12.2050 and the table with dimensions / facts. now i would like to calculate a formula, so only the dates, which have values in the dimension table are showes. I created a formula, but with this formula, all dates - till 31.12.2050 are showed:

but i like to have a formula which shows only the dates till 2030.

thanks for your help

best regards

[Anonymous]

Hi @hnk1 ,

You can update the formula of measure [%Veranderung] as below:

%Veranderung =
CALCULATE (
IF (
DIVIDE ( [Studis], [Studis VJ], 0 ) = 0,
BLANK (),
DIVIDE ( [Studis], [Studis VJ], 0 ) - 1
),
FILTER ( 'Date', 'Date'[Date] <= MAX ( 'px-x-1509090000_112 (1)'[Datum] ) )
)

If the above method is not working, please provide some sample data of two tables with Text format and the formula of measure [Studis ] and [Studis VJ]. And if the field [nur bebuchte wete] is from a measure or calculated column, please also provide its formula. Thank you.

Best Regards