[FONT="]Hi all[/FONT]
[FONT="]At Power Bi how to make it?[/FONT]
[FONT="]If the customer have positive for continuous 4 days, will automatic show how many days.No matter on which day, as long as continuous 4 days.[/FONT]
[FONT="]example 1: kent continuous already exceed 4 days (positive) , he total got 6 days (positive). then automatic show me 6 days...[/FONT]
[FONT="]example 2: ABBY total got 5 days (positive), but she is not continuous 5 days (positive), so just show me 0[/FONT]
[FONT="]Thanks[/FONT]
sample:
this is data
<tbody>
</tbody>
i want the result to be like this
<tbody>
</tbody>
[FONT="]At Power Bi how to make it?[/FONT]
[FONT="]If the customer have positive for continuous 4 days, will automatic show how many days.No matter on which day, as long as continuous 4 days.[/FONT]
[FONT="]example 1: kent continuous already exceed 4 days (positive) , he total got 6 days (positive). then automatic show me 6 days...[/FONT]
[FONT="]example 2: ABBY total got 5 days (positive), but she is not continuous 5 days (positive), so just show me 0[/FONT]
[FONT="]Thanks[/FONT]
sample:
this is data
Date | Name | Value | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
1/5/2019 |
<tbody> </tbody> |
<tbody> </tbody> | |||
1/5/2019 |
<tbody> </tbody> |
<tbody> </tbody> | |||
1/5/2019 |
<tbody> </tbody> |
<tbody> </tbody> | |||
1/5/2019 |
<tbody> </tbody> |
<tbody> </tbody> | |||
1/5/2019 |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
i want the result to be like this
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | 6 | ||
<tbody> </tbody> | 0 | ||
<tbody> </tbody> | 6 | ||
<tbody> </tbody> | 0 | ||
<tbody> </tbody> | 0 | ||
<tbody> </tbody> | 0 |
<tbody>
</tbody>