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

yes.  the dim_comment table has all the comments over the course of time. The comment can be different from one month to the next.  But I want my result to only show one row, i.e, the comment where the date matches the maximum date selected in the slicer.