Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

restart measure

Good day, it is my first post, and the truth totally beginner in this world of Power Bi, I hope to be able to expose my topic clearly. I have a measure which adds data from the last 7, 30, 90 and 3...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi ayalangel 
    It is the same approach. You just need to aggregation column following the aggregation level in the table visual. For example if you are aggregating at month level you need to iterate over the VALUES ( TableName[Year Month Number] ) If you don;t have this column in your table/Date table you can easily create it (Year Month Numbe "Calculated Column" = YEAR ( [Date] ) * 100 + MONTH ( [Date] ) will be just perfect for this application). Please refer to attached sample file.

    For quarter or year level just follow the same.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Syndicate_Admin 

 

You can try the following methods.

Sample data:

Day can also be replaced by consecutive dates.

Measure:

Total = 
Var Zeroday=CALCULATE(MAX('Table'[Day]),FILTER(ALL('Table'),[Value]=0))
Var Sumvalue =CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Day]<=MAX('Table'[Day])&&[Day]>Zeroday))
return
Sumvalue

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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