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 where bin = 30, is there a way to do that? 

Need Help

1 Reply

  • 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