Forum Discussion
Cost / Value Transported Indicator
Hello, PBI community! Need help.
Need Help
Goal:
My objective is to make a division to obtain a 'Cost / R$ Transported' indicator always from my 'last period' or 'month to month' or 'daily'.
However, my 'Numerator' is a fixed monthly data ('DRE' [ORÇAMENTO]) from the query 'DRE' and my 'Denominator' is a data that varies daily ('fsg3342' [VLR MERC]).
'DRE' ORÇAMENTO'fsg3342' VLR MERC
Problem:
I have only one release per month on 'DRE' [ORÇAMENTO] and several releases within a day on 'fsg' [VLR MERC].
What I managed to think, but still doesn't answer me:
Custo/R$ Transportado = CALCULATE(
DIVIDE(
SUM('DRE'[ORÇADO]),SUM('fsg3342'[VLR MERC]),0)
)
Could anyone help me?
Ty
Hi Anonymous
Have you created relationships between tables? I suggest linking both tables to Calendar table and then the measure will work. You may download the PBIX file.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
1 Reply
Hi Anonymous
Have you created relationships between tables? I suggest linking both tables to Calendar table and then the measure will work. You may download the PBIX file.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.