Pull exact value from bin

[hhoward8]

Hi everyone,

Is there a way to retrieve the exact value from a bin based on another measure?

For example, if I created a bin for dates (size 30, so monthly) and wanted to see Total Revenue where bin = 30, is there a way to do that? 

[v-jiascu-msft]

Hi @hhoward8,

It seems a basic need. Can you share a dummy sample please? Some tips:

1. Add a column of bin to the date table;

2. Try out function Summarize;

3. Create a new table of bins and establish relationship.

Best Regards,

Dale