Forum Discussion
Drooopy
2 years agoRegular Visitor
Filtrage des dynamique des rapports
Bonjour, Je débute avec power BI; j'ai une table de référence qui contient des intervales de dates; c'est des données de périodes. Exemple Campagne 1, de 2020 à 2030, Campagne 2, de 2022 à 2032, ...
- Anonymous2 years ago
Hi Drooopy ,
You can create a measure as below to get it, please find the details in the attachment.
Sum of value = VAR _selcamps = ALLSELECTED ( 'Table'[Campaign] ) VAR _syears = CALCULATETABLE ( VALUES ( 'Table'[Start] ), FILTER ( 'Table', 'Table'[Campaign] in _selcamps ) ) VAR _eyears = CALCULATETABLE ( VALUES ( 'Table'[End] ), FILTER ( 'Table', 'Table'[Campaign] in _selcamps ) ) RETURN CALCULATE ( SUM ( 'Data'[Value] ), FILTER ( 'Data' , 'Data'[Year] in _syears ||'Data'[Year] in _eyears ) )Best Regards
lbendlin
2 years agoSuper User
Not really sure what you are asking for.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.