Forum Discussion

ilana105's avatar
ilana105
Helper I
8 years ago
Solved

Problem with date filter when sum

Hello community,   I have a problem of data filtering when I want to calculate a sum. The problem is the following:   I want to calculate the sum of OCP based on the arrival date, departure date ...
General Comment
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi ilana105,

     

    In your scenario, you can create a calendar table which contains continues date and corresponding month name. Create a measure compares calendar date with arrival date, departure date and insert date. Please drag the month column from calendar table to the table visual. 

     

    If you are not able to work it by yourself, please share some sample data and show us the corresponding desired results for our analysis. 

     

    Best Regards,
    Qiuyun Yu 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi ilana105,

 

In your scenario, you can create a calendar table which contains continues date and corresponding month name. Create a measure compares calendar date with arrival date, departure date and insert date. Please drag the month column from calendar table to the table visual. 

 

If you are not able to work it by yourself, please share some sample data and show us the corresponding desired results for our analysis. 

 

Best Regards,
Qiuyun Yu