cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Ayuda con el uso de la tabla de dimensiones de fecha

Hola

Obtengo datos de mi base de datos SQL con Meses como encabezados de columna y los valores inferiores. Quiero realizar cálculos financieros basados en el tiempo, así que hice una tabla de dimensiones de fecha. (https://radacad.com/all-in-one-script-to-create-date-dimension-in-power-bi-using-power-query)

La pregunta es cómo conecto ambas tablas. Mi tabla SQL tiene este aspecto

Nombre de la unidad ? Enero ( Jan) Feb ? Mar (Mar) Abr ? Mayo de Junio ? XXX ? Diciembre

Saludos

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@SimonSeez , Despníte la tabla crea una fecha

fecha: "01-" & [Mes] & "-"& [Año]

O

fecha: "01-" & [Mes] & "-2020"

Mes que obtendrá de unpivoting



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

@SimonSeez , Despníte la tabla crea una fecha

fecha: "01-" & [Mes] & "-"& [Año]

O

fecha: "01-" & [Mes] & "-2020"

Mes que obtendrá de unpivoting



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Hello @amitchandak  

 

Thank you for your assistance with my previous question. I have another variant of the same problem. This time I have a much longer list of rows. Actually, about 2,000 customers with monthly figures of revenue generated. Would you still recommend unpivoting to enable me to get a single date column which I can connect to my calender table? 

 

See sample table 

 

Customer Name | Customer ID | Jan Revenue  | Feb Revenue | Mar Revenue | xxxxxxxx | Dec Rev 

 

Hope to read from you. 

 

Best Regards,

Simon 

Sí, todavía debe usar "Despivot Otras columnas"


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Muchas gracias @amitchandak

Esto resolvió el problema.

Saludos

Simon

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.