Forum Discussion

Helper I

10 years ago

Solved

Using Time Intelligence to calculate Sales in Previous Period

Hi everyone, I'd like to use the Time Intelligence functionalities in PowerBI Desktop, however they do not work as expected. The data model is quite simple. I have a table named Sales from ex...

Need Help

MattAllington
10 years ago
Andwu wrote:

I do not get your comment "This assumes you are not using any columns from the sales table on your visualization".
Of course I have use some columns from this table, as in this table there are my facts, so I don't get it.

I was refering to the columns slicing your data, not the data itself. If you use a column from your sales table in your slicers, then this will not work.

I just tested this and it works for me.

MattAllington

Community Champion

10 years ago

Andwu wrote:

I do not get your comment "This assumes you are not using any columns from the sales table on your visualization".
Of course I have use some columns from this table, as in this table there are my facts, so I don't get it.

I was refering to the columns slicing your data, not the data itself. If you use a column from your sales table in your slicers, then this will not work.

I just tested this and it works for me.