cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Create Table 1 row multiple columns

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.

1 ACCEPTED SOLUTION
Community Champion

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!

6 REPLIES 6
Helper I

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

Community Champion

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!

Helper I

Hello,

Thanks for your input.

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

Super User

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

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!

Helper I

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

Community Champion

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!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors