Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ydundar
Frequent Visitor

incorrect syntax for 'in'

Hey guys,

 

I am getting data from analyses services to create power bi report. But sometimes  I need to create measure based on user selelected values in report side. To getting sales data of selected months I am using below dax query. But it doesn't work. It gives incorrect syntax error. Because of some reason I can not create relationship with Month table and factSalesAmount table. Thanks in advance.

The query is:

SelectedMonthsSalesAverage = CALCULATE(SUM(factSalesAmount[CIRO]), FILTER(factSalesAmount, MONTH(factSalesAmount[TARIH]) IN VALUES(Months[Month]) ))

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors