I have a data set that covers multiple years. However, one part of the analysis requires me to know how many days have passed in the latest year that exists within the data set.
So, for example, I may have a dataset that has 2016, 2017 and 2018 data. In this case I would want Power BI to return 01/01/2018, as the first day of the latest year in my data. I can then look at the last day in my dataset (which I have already created a simple measure to calculate) and see how many days have passed in 2018.
Any help would be much appreciated.
Solved! Go to Solution.