Any help would be appriciated. My fiscal Year starts on the 1st of April, i have created the enclosed
I am trying to create a measure which will bring back previous years sales baed on the FISCAL year ie 2015/2016 and 2016/2017
any help would be appricated
Solved! Go to Solution.
I am not able to succesfully calculate the PFYTD value using your formula above. I have created a date dimension table which is limited to the scope of dates in my fact table. My fiscal year also starts on 1 April and ends on 31 March. It seems that the formula does not go back to the previous FY and still looks at the latest FY.
I am comparing the result i get in Power BI to the PFYTD value which i calculate below. Perhaps i am not comparing like with like?
A.DATE_KEY = B.DATE
B.FISCALYEAR = '2018'
DATE(a.PO_DATECREATEDHEADER) >= '2017-04-01 00:00:00' AND DATE(A.PO_DATECREATEDHEADER) < '2017-04-14 00:00:00'
Hi All, I am having great trouble with this previous fiscal year to date.
Firstly, my year to date DAX:
Booked Sales = SUM(vw_fact_booking[net_total_amt])
Booked Sales FYTD = TOTALYTD([Booked Sales],dates[Date], "30/06")
Booked Sales PFYTD = CALCULATE([Booked Sales FYTD],DATEADD(dates[Date],-1,YEAR))
However, it does not work.
If I filter on date table from (yyy-mm-dd) '2017-07-01' to '2018-01-13', then the figure is different, very different (like 170% more) than to what shows up for PFTYD run as of today.
Any ideas why?
Howdy Jak82 -
The example provided above is based on 1st July, if you want to do 1st June, just change the end date to 31/05 like below:
Booked Sales FYTD = TOTALYTD([Booked Sales],dates[Date], "31/05")
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.