Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Grouping Data by Time Frame

I would like to group data into buckets based off the number of days from which the data is ran.  Here is a sample of what my data looks like.   PMT_AMOUNT CHECK_DATE $10.00 9/5/2017 $75...
Need Help
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

    After my research , you can do these follow my steps like below:

    Step1:

    Add a ran date column

    for example:

    Step 2:

    Add a Time Frame column:

    Time Frame = IF(DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)>=30&&DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)<=120,"90-120 Days",IF(DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)>120&&DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)<=180,"121-180 Days",IF(DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)>180,"181 and greater")))

    Step 3:

    Drag filed Time Frame,PMT_AMOUNT,CHECK_DATE into table visual, and change the aggregate type of filed CHECK_DATE to Count.

     

    Result:

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
8 years ago

After my research , you can do these follow my steps like below:

Step1:

Add a ran date column

for example:

Step 2:

Add a Time Frame column:

Time Frame = IF(DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)>=30&&DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)<=120,"90-120 Days",IF(DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)>120&&DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)<=180,"121-180 Days",IF(DATEDIFF(Table2[CHECK_DATE],Table2[Ran date],DAY)>180,"181 and greater")))

Step 3:

Drag filed Time Frame,PMT_AMOUNT,CHECK_DATE into table visual, and change the aggregate type of filed CHECK_DATE to Count.

 

Result:

Best Regards,

Lin