Forum Discussion
Rolling Date Range
Hi,
I'm attempting to create rolling date range, however, the basic statement I' m using to pull back the prior 7 days worth of data keeps giving an error. I would truly appreciate any assistance to fix this in the Advance Editior.
{Cube.ApplyParameter, "DateRange", Date.AddDays(Date.From(DateTime.LocalNow()),-1), Date.AddDays(Date.From(DateTime.LocalNow()),-8)},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day", "hour"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day", "Date Granularity.Level 4: Hour"}},
{Cube.AddAndExpandDimensionColumn, "evar2", {"evar2"}, {"Platform (v2)"}},
{Cube.AddMeasureColumn, "Unique Visitors", "uniquevisitors"}
})
in
#"Added Items"
Error:
Expression.Error: 4 arguments were passed to a function which expects between 2 and 3.
Details:
Pattern=
Arguments=[List]
Hi Anonymous ,
Based on your description, you can modify the function as follows.
{Cube.ApplyParameter, "DateRange",List.Dates(Date.AddDays(Date.From(DateTime.LocalNow()),-8),7,#duration(1,0,0,0))},{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day", "hour"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day", "Date Granularity.Level 4: Hour"}},
{Cube.AddAndExpandDimensionColumn, "evar2", {"evar2"}, {"Platform (v2)"}},
{Cube.AddMeasureColumn, "Unique Visitors", "uniquevisitors"}
})
in
#"Added Items"Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
34 Replies
Hi Anonymous ,
Based on your description, you can modify the function as follows.
{Cube.ApplyParameter, "DateRange",List.Dates(Date.AddDays(Date.From(DateTime.LocalNow()),-8),7,#duration(1,0,0,0))},{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day", "hour"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day", "Date Granularity.Level 4: Hour"}},
{Cube.AddAndExpandDimensionColumn, "evar2", {"evar2"}, {"Platform (v2)"}},
{Cube.AddMeasureColumn, "Unique Visitors", "uniquevisitors"}
})
in
#"Added Items"Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
Could you tell me if your problem has been solved? If so, please accept it as the solution. More people will benefit from it. Or you're still confused about it, please give me more details about your problem.
Best regards
Yuna
