Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Rolling Date Range

‎03-16-2021 09:19 AM

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]

Labels:
Message 1 of 35
2,313 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable

‎03-18-2021 02:52 AM

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.

View solution in original post

Message 3 of 35
2,203 Views
0
34 REPLIES 34
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:26 AM

Don't @deionb44,

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

Message 35 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:23 AM

Don't @deionb44,

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

Message 34 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:20 AM

Don't @deionb44,

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

Message 33 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:18 AM

Don't @deionb44,

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

Message 32 of 35
1,664 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:15 AM

Don't @deionb44,

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

Message 31 of 35
1,664 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:12 AM

Don't @deionb44,

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

Message 30 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:09 AM

Don't @deionb44,

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

Message 29 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:06 AM

Don't @deionb44,

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

Message 28 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:03 AM

Don't @deionb44,

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

Message 27 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 03:01 AM

Don't @deionb44,

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

Message 26 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:58 AM

Don't @deionb44,

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

Message 25 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:55 AM

Don't @deionb44,

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

Message 24 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:52 AM

Don't @deionb44,

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

Message 23 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:50 AM

Don't @deionb44,

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

Message 22 of 35
1,663 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:47 AM

Don't @deionb44,

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

Message 21 of 35
1,664 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:45 AM

Don't @deionb44,

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

Message 20 of 35
1,671 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:43 AM

Don't @deionb44,

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

Message 19 of 35
1,674 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:40 AM

Don't @deionb44,

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

Message 18 of 35
1,674 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:38 AM

Don't @deionb44,

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

Message 17 of 35
1,674 Views
0
Syndicate_Admin
Administrator
Administrator

‎04-06-2021 02:36 AM

Don't @deionb44,

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

Message 16 of 35
1,674 Views
0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All