Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix issue

Created one calculated column for combining year and month. After filtering year, matrix is showing all yeras. Please help.      
  • Anonymous's avatar
    Anonymous
    5 years ago

    amitchandak , Pragati11 

    Removed coalesce function from measure, resolved my issue.  Thanks everyone. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes, I have universal calendar table, and created one calculated column.

MMM_YYYY = FORMAT(Dates[Date],"MMM") & "_" & FORMAT(Dates[Date],"yyyy")
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , This can be

MMM_YYYY = FORMAT(Dates[Date],"MMM_yyyy")

 

But this can nor cause that issue. Make share date table is joined (active join) with your fact and filter of year and month is coming from date table