Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Ignore Filter on Month level with Summarize

I have a requirement where I have to do the currency conversion for my measure on row level and add them up to get correct data on top levels . Data in my  'Balance Sheet Measures', is available for ...
  • mark_endicott's avatar
    mark_endicott
    2 years ago

    I am assuming you have a relationship between 'Date - Report'[DETL_ReportDateSurrogateKey] and a date column in your currency table.

     

    One way to solve this would be to create a "Day of Month" column in each, and use this as your relationship and inside the summarize. This would make it agnostic of the Month. 

     

    If you have multiple years, you would just need to add this into the column you create. It would result in a many to many join, so would need to be tested. But it's the simplest route without getting into over complex DAX. 

mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
2 years ago

I am assuming you have a relationship between 'Date - Report'[DETL_ReportDateSurrogateKey] and a date column in your currency table.

 

One way to solve this would be to create a "Day of Month" column in each, and use this as your relationship and inside the summarize. This would make it agnostic of the Month. 

 

If you have multiple years, you would just need to add this into the column you create. It would result in a many to many join, so would need to be tested. But it's the simplest route without getting into over complex DAX.