creating dax that shows the total month result when i select a week in my filters.

DarkNicobak — Tue, 16 Aug 2022 20:35:35 GMT

Im having some trouble creating a measure that shows the total month result when i select a week in my filters.
My dashboard is filtered by year and week, and this measure is a sum of the total values in a collumn but must be displayed as a monthly result, not weekly
My goal would be to select week 1, and have the total result for January, select week 5 and have the total result for February, etc

Re: creating dax that shows the total month result when i select a week in my filters.

RayWu — Tue, 16 Aug 2022 20:38:44 GMT

Hi DarkNicobak i recommend using this article: https://dax.guide/hasonevalue/ to check if the yyyy-mm column has one value, then calculate the measure based on an unfiltered version but then filtered aginst that yyyy-mm

topic Re: creating dax that shows the total month result when i select a week in my filters. in DAX Commands and Tips

creating dax that shows the total month result when i select a week in my filters.

Re: creating dax that shows the total month result when i select a week in my filters.