Forum Discussion

shri2785's avatar
shri2785
Frequent Visitor
3 years ago
Solved

Issue with Constant date value in slicer

Hi Power BI Gurus,    I have tried to create a slicer for YTD, QTD, MTD using some links on web.  Below is the code for the same  Time_Frame = VAR TodayDate = Today() VAR YearStart = Calculate(...
  • Wilson_'s avatar
    Wilson_
    3 years ago

    Hello shri,

     

    You don't need to include the year in the second parameter in STARTOFYEAR; you can just use "12/31" instead of "12/31/2023". That might solve your issue. I can't quite tell what you're trying to accomplish.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Wilson_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
3 years ago

Hello shri,

 

You don't need to include the year in the second parameter in STARTOFYEAR; you can just use "12/31" instead of "12/31/2023". That might solve your issue. I can't quite tell what you're trying to accomplish.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

  • shri2785's avatar
    shri2785
    Frequent Visitor
    3 years ago

    Hi Wilson, thanks for the response, and it worked for me. I am trying to create a slicer with the list of dates to be passed for measure calculations.

     

    There is one more hurdle i am facing 

    we have something called as ficsal_period_start_date in dim_cal

     

    when i try to reference to this it give me circular ref error.

    May i know how we can get this done...

     

    Basicall i need 

    YTD

    QTD

    PTD 

    as slicer options.Thanks