Forum Discussion
Anonymous
2 years agoNot applicable
power bi
ned help solving this measure Vin_no_count_Old_slot_date = CALCULATE(Query1[Vin_no Count], FILTER(Query1, Query1[oldest_slot_dt].[Year] < 2024)) actually I want the date to show as 01-01-2024 ...
Ashish_Mathur
Super User
2 years agoHi,
You should first of all create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. Create a relationship (Many to One and Single) from the Date column of yoru Data Table to the Date column of the Calendar Table. Write this measure
Vin_no_count_Old_slot_date = CALCULATE([Vin_no Count], Calendar[Date] < date(2024,1,1))
I have assumed that Vin_no count is an explicit measure that you have written.