Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Please help me.
How to create Forecast DAX and How To show Actual Sales and forecast value in Line Chart. Historical data given below .
Month Year | Total Sales |
Apr-19 | 78165665.39 |
May-19 | 91279485.5 |
Jun-19 | 83674041.81 |
Jul-19 | 80537993.48 |
Aug-19 | 94154641.43 |
Sep-19 | 106796628.5 |
Oct-19 | 80450504.6 |
Nov-19 | 100583313.3 |
Dec-19 | 112743146.5 |
Jan-20 | 94727635.33 |
Feb-20 | 135227208.7 |
Mar-20 | 18913186.51 |
Apr-20 | 92899087.27 |
May-20 | 136980726.5 |
Jun-20 | 159237486.4 |
Jul-20 | 150313041.4 |
Aug-20 | 137974667 |
Sep-20 | 145085582.8 |
Oct-20 | 137327817.6 |
Nov-20 | 161502025.8 |
Dec-20 | 179046216 |
Jan-21 | 125322274.9 |
Feb-21 | 144305022.4 |
Mar-21 | 95365999.23 |
Apr-21 | 102190038.1 |
May-21 | 148124924.9 |
Jun-21 | 173173211 |
Jul-21 | 159688838.8 |
Aug-21 | 150855730.1 |
Sep-21 | 130901038.7 |
Oct-21 | 173999447.7 |
Nov-21 | 133510986.5 |
Dec-21 | 180484264.1 |
Jan-22 | 151134370.6 |
Feb-22 | 165883273.1 |
Mar-22 | 163149254.4 |
Hi @shri0025 ,
What 's the logic of Forecast sale, could you please give an example for a date.
Best Regards,
Community Support Team _ kalyj
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |