Forum Discussion
The start date or end date in Calendar function can not be Blank value.
Hello ,I'm New for power Bi and dax function
I want to create MTD YTD Slicer Based on date Column .
I try to create slicer using following DAX Function
The start date or end date in Calendar function can not be Blank value.
9 Replies
have you try to use MIN instead of startofyear?
What's more, you can try to return yearstart and monthstart to see if the output is blank or not
ryan_mayu Thank you ,
Even after trying the MIN function, the error persists. The Date column contains date values and is not blank.
Date column is in Sale Time table And sales value is in electric car table ,
is there need to relation between them?
in both table car sold is common columnmaybe you can try this
VAR YearStart = CALCULATE(STARTOFYEAR(SalesTimeline[Date]), filter(SalesTimeline,YEAR(SalesTimeline[Date]) = YEAR(TODAYDATE) && not (isblank(SalesTimeline[Date]))
I didn't see you usesales value in the DAX.
What did you get if you return YearStart or return MonthStart?
if the issue is still existing, could you pls share the pbix file?
I want to Create field parameter for MTD ,YTD ,QTD of car sales.
Kindly Giude And Help me for the Same .pls see if this is what you want
