Handling of different time dimensions

[Anonymous]

Hello all,

I have, according to me, a tricky question about how to cope with two different time dimensions.

I have this data in my only table:

OrderId	OrderDate	OrderYear	OrderMonth	InvoiceDate	SalesAmount
A	2015-01-04	2015	Jan	2015-02-01	100.000
B	2015-11-15	2015	Nov	2016-01-31	50.000
C	2015-04-01	2015	Apr	2015-07-01	200.000

The total sales amount is 350.000, no selections.

I select 2015 as my OrderYear. The total sales amount is still 350.000, with OrderYear = 2015 as my only current selection.

Now to my point: As I have chosen 2015 as OrderYear I would like to create an expression that presents SalesAmountThatWillBeInvociedThisYear e.g. order A and C with the total value of 300.000.

Is that possible through an expression/set analysis? Or should I mess around with my time dimensions in my data model? Of course I have a hundred thousands of records and this is just a simple example.

Have I made clear what I am trying to receive?

Thanks for possible solutions.

Best,

Filip

[Anonymous]

Thanks for helping me find the blog post about the Canonical Date.
That helped on the way solving my problem.

[sunny_talwar]

Awesome

I am glad that finally you were able to solve your problem.