Forum Discussion

Trammie's avatar
Trammie
New Member
8 years ago
Solved

making sap hana parameters input dynamic

Hi,   I'm trying to connect a power BI report to a SAP HANA database which requires in put of a Date parameter. I've copied the DAX code that was generated below, relating to the "Report_Date" para...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi Trammie,

     

    Try M code like below and check if it can work:

     

    Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)

    Regards,

    Jimmy Tao 

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Trammie,

 

Try M code like below and check if it can work:

 

Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)

Regards,

Jimmy Tao 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Great suggestion. 

     

    I have used it as follows to get the current year and previous month, works like a charm.

     

     

    The only drawback is : now the 'Added Items' screen can not be invoked, all further changes need to be done via the advanced query editor

     

     

    Thanks!