Can Summarize column slicer by date?

Question

Hi all,&nbsp;I'm trying to calculate a cost per call column from a table has&nbsp; columns&nbsp;date;&nbsp; total labor per date ; total orders per date&nbsp;&nbsp;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&nbsp;Thanks&nbsp;

greg_deckler · Answer

Some sample data and expected output would help tremendously.&nbsp;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

anonymous · Answer

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 · Answer

HI&nbsp;Anonymous&nbsp;,
&nbsp;
Unfortunately, you can't create a dynamic calculated table/column based on&nbsp;use slicer/filter.
&nbsp;
Regards.
Xiaoxin Sheng

Forum Discussion

Can Summarize column slicer by date?

3 Replies

Related content

Parameter in summarize

Slicer for filtering several columns

Summarize Multiple Columns

Don't Summarize....still summarizes...?

Different Groupby Column Names in Summarize