Forum Discussion
Anonymous
6 years agoNot applicable
DATEADD not aggregating
Hello, I'm trying to create a measure where I calculate revenue recognized on a sales order in specific timeframes (see below table). I'm using two measures calculating revenue then % of revenue ag...
v-lili6-msft
6 years agoCommunity Support
hi Anonymous
You need a dim date table and then use it with Time Intelligence function in dax
https://radacad.com/do-you-need-a-date-dimension
If you still have the problem, please share your sample pbix file and your expected output.
Regards,
Lin