Forum Discussion

Anonymous

Not applicable

4 years ago

Contiguous date problem with Country filter

Hello, In my current project, I have following three tables: 1) date dimension table where I have dates for everyday since 2019 2) country master table 3) website data table (which has a many-...

Need Help

Greg_Deckler

Community Champion

4 years ago

Anonymous Can you change the relationship cross-filter direction to Single from Both? Also, I would add this column to your financial calendar:

FiscalDayOfYear = 
  VAR __Date = [Date]
  VAR __FinancialYear = [Financial Year]
RETURN
  COUNTROWS(FILTER('Dates',[Financial Year]=__FinancialYear && [Date]<=__Date))

Anonymous

Not applicable

4 years ago