Forum Discussion
creating a Fiscal year date table
Hi guys, i want to calculate the sales ACCORDING TO THE FISCAL YEAR ia am having the date table starting with January. i want to create a date table starting with Fiscal year month (Eg : month starting with 1st April 2018 and end on 31st march 2019). How can i do it. Kindly provide me any solution or Query for it.
- Hi Anonymous ,You can refer to this blog, and it will help you solve the problem .(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- Please have a look at this answer.
https://community.powerbi.com/t5/Desktop/Financial-Year-Calendar/m-p/854820/highlight/true#M410198
If this helped, please mark this as the solution. Kudos are welcome!:) - Hi Anonymous ,You can refer to this blog, and it will help you solve the problem .(Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Hi Anonymous ,
Is this problem sloved?
If the problem persists, please let me know.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft Yes thanks the problem is solved
- Please accept whichever answer was the right one so people with the same issue can find the solution as well 🙂
