multiple Set analysis

[rolandg1881]

Hi!

Hope you are all fine!

I've one question please.

I have the following set analysis:

sum({<[Value] = {'Workdays'}>}[Days])

the is the sum of Days which where Workdays other Values are for example 'Holidays'.

What i need is this: for example i chose the Month from January to July  in the Report

BUT in this field i only want to see the 'Workdays' from July (max(month).

Is there any solution where i can say in set analysis value for max(month) ?

Thank you!

Roland

[Vegar]

This expression should do what you're asking for. 

sum({<[Value] = {'Workdays'}, [Month] ={'$(=MaxString ([Month] )) ' } >}[Days])

[rolandg1881]

Hi!

Thank you for your help!

Looks good but wont work. 😉

sum({<[Buchungsart] = {'Zeitausgleich'}, [AMS_Monat] ={'$(=MaxString ([AMS_Monat] )) ' } >}[Nettozeit])

if i take this formula:

Sum({<[Buchungsart]={'Zeitausgleich'}>}[Nettozeit])

and chose only July it works but i need to chose March to July for other formulas in the report

AMS_Monat arte the months i chose in the picture but the value for [Nettozeit] and July shows 0 for very row with this formula. 😞

[rolandg1881 · Accepted solution]

It works only the ' was wrong.

sum({<[Value] = {'Workdays'}, [Month] ={$(=MaxString ([Month] )) } >}[Days])

Thaaaaank you!