Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good morning
Using the web, I have a formula to give me a slope value. However I have 2 problems and i would like your guidance on it.
Problem 1. I need the measure to only look at the past 90 days.
Problem 2. The Y value is stored as a 1 or 0 to indicate when an event happens. The event can happen multiple times a day and it the count of those events which i need to form my Y value in the calculation.
How would I modify the measure below to address my two problems.
Apart from the date issue, i think my issue is that after the "average" function in the varx and var y, i need to count the number of events per day and i do not know how to.
I look forward to any assistance.
Lola
Hi @Anonymous ,
Refer the following article ,and check if it is helpful:
Best Regards
Lucien
@v-luwang-msft Good morning. The formaula i used came from that site. I would appreciate help modifying the formula as I described above.
Lola
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |