Forum Discussion

ldwf's avatar
ldwf
Helper V
4 years ago
Solved

Create a Measure on Text Field

Hello, I have a star schema PBI model.  I have a dimension table with comment field,.  I have a date slicer where the user can select multiple dates from a date dimension table.  I want to use the ma...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    ldwf 

    Except you were filtering the Dim_Date[Date] column while you should be filtering the Dim_Comments[Date] column

ldwf's avatar
ldwf
Helper V
4 years ago

I have tried this before as well, but it always returns the maximum comment, not the comment corresponding to the maximum date selected in the slicer.

tamerj1's avatar
tamerj1
Community Champion
4 years ago

ldwf 

Except you were filtering the Dim_Date[Date] column while you should be filtering the Dim_Comments[Date] column

  • ldwf's avatar
    ldwf
    Helper V
    4 years ago

    That was it!