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: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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,418 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,308 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,728 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,728 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,728 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,729 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,729 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,728 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,728 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,728 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,728 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,728 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,728 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,728 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,728 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,728 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,729 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,736 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,739 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,739 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,739 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,739 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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

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