SSAS and Current month

[Alex_G7]

Hi 

 Data comes from SSAS  with Date dimenssion 

Is anyway start Dashboard or Report displaying Current month?

[MauriceMecowe]

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]

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]

Please see attached picture

[Alex_G7]

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

[MauriceMecowe]

Could you please tell me which version of power bi you are using?

[Alex_G7]

Version: 2.70.5494.761 64-bit (June 2019)

[MauriceMecowe · Accepted solution]

@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.