Solved: Re: Create Table 1 row multiple columns

Anonymous · ‎09-09-2022

Hello,

How do you create a table with 1 row and multiple columns with data?

I am trying to get this into a table
EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1 ), -1)
EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1),-2)

I've had a go at using the DATATABLE function, had no success.

PaulDBrown · ‎09-11-2022

This works:

new table =
{
( EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -1 ), EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -2 ) )
}

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

View solution in original post

Anonymous · ‎09-10-2022

This is the error I get when using the DATA Table Function.

PaulDBrown · ‎09-10-2022

Try

{(EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1 ), -1),
EOMONTH(DATE (YEAR(TODAY()), MONTH(TODAY()), 1),-2)}

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Anonymous · ‎09-10-2022

Hello,

Thanks for your input.

I have tried this also, which gave me this error.

VijayP · ‎09-10-2022

@Anonymous

Quesion is bit unclear! Can you share a snapshot how you want to see the data!

Matrix table should help you right?!!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!

Anonymous · ‎09-10-2022

Hello,
This is what I want to see if the date is 11 September 2022.

PaulDBrown · ‎09-11-2022

This works:

new table =
{
( EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -1 ), EOMONTH ( DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ), 1 ), -2 ) )
}

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.