Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Summing Values BETWEEN Two Dates AND Count consecutive days In Power BI

如何寫出出量值，可以計算出篩選的範圍日期，每天連續請求2件，天算超過一次    
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi  Anonymous ,

    Create measure.

    mod_measure = MOD(MAX('Table'[rank]),2)
    Over_TWO_measure =
var _current=SUMX(FILTER(ALL('Table'),'Table'[Date]=MAX('Table'[Date])),[count])
var _next=
IF(
    MAX('Table'[Date])=MINX(ALL('Table'),'Table'[Date]),_current,
SUMX(FILTER(ALL('Table'),'Table'[Date]=MAX('Table'[Date])-1),[count]))
return
IF(
    _current=_next&&MAX([count])>=2&&[mod_measure]=0,1,0)

    Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Anonymous ,

 

I recommend that you can upgrade Power BI Desktop to the latest version.

Because in the process of version upgrade, the previous functions will be continuously optimized and more comprehensive new functions will appear, and many contents are compatible with the latest version.

What’s new in the lastest Power BI update?

Latest version of Power BI Desktop

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI, v-yangliu-msft

    I want to upgrade, too,but  the company does not give.

    by theway if I want to over_two change over_three how to change ?

     

    I try it but it doesn't work

    thank you