How to get day and month from date

[#1]

Hi all,

i have a table like this

Day	values
2012/01/01	2
2012/06/01	3
2013/01/01	7
2013/06/01	4

if a select 2012/01/01 from a combo box i need that in a graph wiil be only the values where day and month are equals(in this case 2 and 7)

tyvm

Simone

[#2]

Hi Jagal,

thanks for your help.

Your solution works fine.

However I need to pass dinamically days and months in the following expressions:

Sum({<Month={1}, Day ={31}>} Measure)

or

Sum({<Month={'Jan'}, Day ={31}>} Measure)

so that assuming

month = 2

day = 24

I would have

Sum({<Month={month}, Day ={day}>} Measure)

Do you have any solution about?

i try with 2 variables vMonth vDay : Sum({<Month={vMonth}, Day ={vDay}>} values)

Regards,

Simone

[jagan]

Hi Simone,

Try like this with variables

=Sum({<Month={$(vMonth)}, Day ={$(vDay)}>} values)

Regards,

Jagan.

[vishwanath]

Hi Simone,

Let's assume, the name of the date column is "InventoryDate" .

So, while importing the table in the Edit Script you can use:

LOAD

       Year(InventoryDate) as InventoryYear

       Month(InventoryDate) as InventoryMonth

       Day(InventoryDate) as InventoryDay

FROM [TABLE_NAME] ;

Now, let's take a sample example of InventoryDate. Suppose, the InventoryDate is 2016-06-15,

So, by using the above load script you will get:

InventoryYear = 2016

InventoryMonth = 06

InventoryDay = 15

Regards,

Vishwanath Biswal