I have a date table, it rus in monthly buckets from 01 July 2019 to 01 June 2022 (4 fiscal years, 48 rows)
My fiscal Year starts on 01 July and ends 30th June.
I have created a YTD measure:
YTD Sales Outlook = TOTALYTD([Sales Outlook], DimDate[LongMonthYear], "06/30" )
Sales outlook is a combination of actual sales and forecasted sales.
When I put it in a table with the Fiscal Years, it shows up correctly.
However, when I put this in a card, it gives me next year sales YTD.
I would like to see this year's YTD
Thanks for the help!
Solved! Go to Solution.
Hi @dapperscavenger ,
When you put this measure in the table then that measure gets filtered by row context whereas when you put this measure in a card then the max date will be taken in the card. For this, you can have a date slicer that will slice a particular date and the results are shown from the year up to that date.
What filter do I need to use in the formua if I want to compare YTD this year with same of previous year ?
i.e. YTD this year would be sales July to March. What are sales July to March this year, and what are sales July to March of previous year? Then I am comparing same period.
No, I don't want to have to use manual slicers for this one, or else I would have to remember to mantain it all the time 🙂
So, to get the previous fiscal year, I would have to do some sort of datadd -1 year I think.
And to show only YTD, I would have to use some sort of this month criteria, rather than 06/30?
@dapperscavenger , if you do not want to select any date field in slicer, then your calendar should end on jun 30, of current year. That will take this year as end date without you selecting it
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.