Forum Discussion

Alex_G7's avatar
Alex_G7
Icon for Helper I rankHelper 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. 

MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver 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
    Icon for Helper I rankHelper I
    7 years ago
  • Alex_G7's avatar
    Alex_G7
    Icon for Helper I rankHelper 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

    • MauriceMecowe's avatar
      MauriceMecowe
      Icon for Resolver II rankResolver II
      7 years ago

      Please see attached picture

       

      • Alex_G7's avatar
        Alex_G7
        Icon for Helper I rankHelper I
        7 years ago

        I don't have option for Relative ..are you showing example when data taken live from SSAS ?