making sap hana parameters input dynamic

Question

Hi,&nbsp;I'm trying to connect a power BI report to a SAP HANA database which requires in put of a Date parameter.&nbsp;I've copied the DAX code that was generated below, relating to the&nbsp;"Report_Date" parameter.&nbsp; Instead of typing in a fixed date, how can I change the parameter so that it is dynamic, say, based on&nbsp;yesterdays date.&nbsp;&nbsp;&nbsp;&nbsp; #"Added Items" = Cube.Transform(CV_STOCKS_SAPDIST_D1,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {Cube.AddAndExpandDimensionColumn, "[CV_STOCKS_SAPDIST_D20]", {"[CV_YCBPARTNR_DIM_SAPDIST].[YCBPARTNR]"}, {"Business Partner"}},&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {Cube.ApplyParameter, "Report_Date", {"20180731"}}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }),&nbsp;&nbsp;ThanksTram

v-yuta-msft · Accepted Answer

Hi&nbsp;Trammie,
&nbsp;
Try M code like below and check if it can work:
&nbsp;
Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)
Regards,
Jimmy Tao&nbsp;

Forum Discussion

making sap hana parameters input dynamic

2 Replies

Related content

Dynamic M Query Parameters not working when I make slicer selection

Dynamic subcription parameter not saving

Sum dynamic parameter fields multiple selected parameter

Make an API call/parameter dynamic

Make Parameter effective using calculated column