Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Problem with Time Intelligence functions

  Hi Everyone!   I have a table with data with one date and one value by row. There is one value for week. I have created My Calendar Table but when I use the Time Intelligence Formulas didn't wo...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Anonymous

 

The DATEADD() function only works for contiguous date selection, which means you need to select contiguous dates into your table visual. In this scenario, you can create a calculated column instead of a measure to workaround this issue.

 

For PREVIOUSMONTH() function, it should work once you create a relationship between your fact table and the full calendar table.

 

See my sample below:

 

 

Previous Month = CALCULATE(SUM('Fact'[Amount]),PREVIOUSMONTH('Calendar'[Date]))
Last Week Column = CALCULATE(SUM('Fact'[Amount]),DATEADD('Calendar'[Date],-7,DAY))

 

 

 

 

Regards,