Forum Discussion

charlieH's avatar
charlieH
New Member
4 years ago
Solved

Date Comparison Incorrect Sometimes

I have three tables which contain dates, I have combined all of the unique dates into one date table. I am interested in creating a True/False condition where I can filter by the maximum date of one ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi charlieH,

    Measure and calculate column work on different levels, current you can't use filter/slicer effect to create a dynamic calculated column/table.
    When measures are used in the calculated column, the row and filter context will be fixed and affect the original measure formula calculation.

    Notice: the data level of power bi(from parent to child level)

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi charlieH,

Measure and calculate column work on different levels, current you can't use filter/slicer effect to create a dynamic calculated column/table.
When measures are used in the calculated column, the row and filter context will be fixed and affect the original measure formula calculation.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng