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.
Hi All,
I have two formulas that compare the base period (months) with the trailing 12 months of average energy consumption.
Base formula: July 2017 to June 2018 (this is always static)
Solved! Go to Solution.
After Date function where you are getting today's Date subtract with 30 get the previous month Date and it should work
Proud to be a Super User!
After Date function where you are getting today's Date subtract with 30 get the previous month Date and it should work
Proud to be a Super User!
@Rubal_Islam Share your Kudos as well by clicking on 👍 Icon!
Proud to be a Super User!
Hi VijayP,
The below formula did the trick and it works like magic.
Proud to be a Super User!
Hi VijayP,
Thanks for reverting to me. The formula almost works. The only issue is my data is I need to calculate from Feb21 to Jan22, Not March 21 to Jan22. I have a month's lag on data. I believe the today function for Month and day calculating it from March 22 , -1 year.
With the Formula, i am getting the below results.
Please Note: 92,664 is the correct result. The Comparison Energy Usage V2 is calulating from Mar21 to Jan22, where as i need to calulate the data from Feb21 to Jan22.
If you please can help how can i change the Month(Today() from Previous Month and Day from Today to Previous Month Day will be greatly appreciated.
Please let me know if I need to clarify any further.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |