Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I need a little help about a question. I´m doing a expression to calculate a value accumulate from day.
Expression atual:
AOP_ = CALCULATE([Actual (R$)];FILTER(ALLSELECTED(V_RELATORIOVENDAS_[DataInclusao]);V_RELATORIOVENDAS_[DataInclusao] <= MAX(V_RELATORIOVENDAS_[DataInclusao]) && V_RELATORIOVENDAS_[DataInclusao] <= TODAY()))
Graphic.
My AOP should be: Day 1, example, 2%, in Day 2 we have more 3%, then, in the Day 2 AOP = 5%.
Who can help me about his???
Thank you!
@ROBERTOCMRNO wrote:
Hi!
I need a little help about a question. I´m doing a expression to calculate a value accumulate from day.
Expression atual:
AOP_ = CALCULATE([Actual (R$)];FILTER(ALLSELECTED(V_RELATORIOVENDAS_[DataInclusao]);V_RELATORIOVENDAS_[DataInclusao] <= MAX(V_RELATORIOVENDAS_[DataInclusao]) && V_RELATORIOVENDAS_[DataInclusao] <= TODAY()))
Graphic.
My AOP should be: Day 1, example, 2%, in Day 2 we have more 3%, then, in the Day 2 AOP = 5%.
Who can help me about his???
Thank you!
What is the measure [Actual (R$)]? You can try below measure
AOP_ = CALCULATE ( [Actual (R$)], FILTER ( ALLSELECTED ( V_RELATORIOVENDAS_), V_RELATORIOVENDAS_[DataInclusao] <= MAX ( V_RELATORIOVENDAS_[DataInclusao] ) && V_RELATORIOVENDAS_[DataInclusao] <= TODAY () ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |