Forum Discussion

Alex_G7's avatar
Alex_G7
Helper I
7 years ago
Solved

SSAS and Current month

Hi 

 Data comes from SSAS  with Date dimenssion 

 

Is anyway start Dashboard or Report displaying Current month?

 

 

 

Need Help
  • MauriceMecowe's avatar
    MauriceMecowe
    7 years ago

    Alex_G7Make sure you are using a date field, otherwise the option won't show. This update for the relative date filtering was already before April 2019, so your version should support this feature. 

8 Replies

  • MauriceMecowe's avatar
    MauriceMecowe
    Resolver II
    7 years ago

    Hi Alex_G7 ,

     

    I would either use the Relative date filtering in the dashboard on your visuals or use the DateTime.LocalNow() function.

     

    Or you can create a period slicer with only the current month. If you would daily update your SSAS model, it would get today's date and then refer to the month of today's date. 

     

    Cheers

    Maurice

    • Alex_G7's avatar
      Alex_G7
      Helper I
      7 years ago

      Hi, 

       

      if possible please show link or picture  showing  option to use Relative date filtering  or DateTime.LocalNow() function

      with Report attached to SSAS

       

      ( I don't see those options or could not locate example of filtering with DAX for SSAS)

       

       

      Thank you

      Alex