Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create average of previous days data

Hi,   I have a table which has workout data for diffrent devices for each day. What I want is to get a threshold value which is 30% of the sum of the previous days.   So if you see below you will...
Need Help
  • YJ's avatar
    YJ
    6 years ago

    Hi,

    just for fun i added in another partner, to show the case when below threshold:

     

    Above is the visual and below is the working columns. for example sake i used date as today()-1 (21st oct)

    I make sure of main cal columns, prehaps a more efficient way would be to use measure, i look forward to other better solution, meanwhile i hope this ans your question.

    attached PBIX: PBIX 

     

    regards

     

     

     

YJ's avatar
YJ
Icon for Resolver II rankResolver II
6 years ago

Hi,

just for fun i added in another partner, to show the case when below threshold:

 

Above is the visual and below is the working columns. for example sake i used date as today()-1 (21st oct)

I make sure of main cal columns, prehaps a more efficient way would be to use measure, i look forward to other better solution, meanwhile i hope this ans your question.

attached PBIX: PBIX 

 

regards

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Thank you so much for this. Just had to make some small tweeks in the threshold formula and I was able to achieve my requirement.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi YJ ,

     

    I had to change my connection mode to DirectQuery mode and now the functions you provided are not working. Can you help please.