Can Summarize column slicer by date?

[Anonymous]

Hi all,

I'm trying to calculate a cost per call column from a table has  columns

date;  total labor per date ; total orders per date

How can i generate a cost per call column that can has (sum of labor cost)/ (sum of orders) and has to be slicerable by the date slicer

Thanks

[Anonymous]

Here is the sample data , I would like to sum up labor cost per date and total orders by date and calculate the ratio between these two sum. But i want the cost per order can be filterable by date slicer( means if the date is 2019-02-01-2019-02-10, it only comes with the ratio in this range

[Anonymous]

HI @Anonymous ,

Unfortunately, you can't create a dynamic calculated table/column based on use slicer/filter.

Regards.

Xiaoxin Sheng

[Greg_Deckler]

Some sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490