Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a Table with Month till Jun'19, and respective amount in a Table1. and have Calender table from Jan'19 to Dec'19.
This is for forecastting and my assumption is to carryforward the value of the current month till the end of the Year. Example, as on June i've june Numbers in place and the current value should carryforward till the end of Dec to acceratin the Revenue(This is an assumption that the June revenue will be expected till Dec'19.)
Example I'll share the requirements
Available Amounts till Jun'19 as below
Required Result:
1. In the Above example, the values are actuals till Jun'19.
2. The number from Jun'19 should caarryforward till Last month of the Year ie till Dec'19.
3. Tried to create a New Table using calender table as months and trying to get the values and replicate the Jun'19 value "9209" till Dec. Please let me know if there is a better option.
Hope i'm good to convey the requirement. Please let me know if you need further details.
Regards,
Solved! Go to Solution.
@Anonymous
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Dax-fill-down-in-formula/m-p/318992#M141935
@Anonymous
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Dax-fill-down-in-formula/m-p/318992#M141935
Try using TOTALYTD. Example
YTD = TOTALYTD(SUM(Sales[Sales Amount]),'Date'[Date Filer])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |