Forum Discussion

hhoward8's avatar
hhoward8
Frequent Visitor
8 years ago

Pull exact value from bin

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 wher...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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