year and month in one colum

[Anonymous]

Hi

how can i have year and month to be just in one column?

thank you

[harshnathani]

Hi @Anonymous ,

Measure = Concatenate (MAX('Table[Year]), MAX('Table'[month]))

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi Harsh

this are my data. for each project for the last 4 months i go an expected end date for the project. everytime i try to create a graph Power BI put a jerarchy for each of those dates, whilst i would like Power BI to give me just one value for month and year together

can you help me somehow?

Project                  Feb       Mar        Apr         May

SMP PH1             04/20    04/20    08/20    09/20

SMP PH2                            08/20    08/20    09/20

FOCUS                  02/21    12/20    12/21    06/22

 iTRACS                03/20    04/20    04/20    05/20

BAM                     07/21    03/22    03/22    03/22

GCAP​                    01/20    06/20    06/20    09/20

HQ UK                  12/19    12/19    09/20    12/20

eSign                   11/19    01/20    01/20    07/20

ROM1​                   09/21    12/21    02/22    02/22

MBP                     12/20    12/20    12/20    12/20

PCC                       06/20    06/20    06/20    09/20

MWP                    05/20    05/20    05/20    05/20

SABRE                  04/20    05/20    06/20    12/20

NRC                      06/20    06/20    06/20    06/20

ICOLO                                 10/20    10/20

[harshnathani · Accepted solution]

Hi @Anonymous ,

To disable date heiararchy,

Also you can go to Files > Option and Settings > Options >> Current File and disable the auto date time.

https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/#:~:text=The%20Auto%20Date%2FTime%20feature%20can%20be%20turned%20on%20or,date%20column%20in%20the%20model.

Can you share the snapshot of how the dates can imported in Query Editor and Power BI Desktop,

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi Harsh

i have this data:

i disabled the heiararchy and now i want to have a stacked colum chart that show me the end-date trend per each project but everytime i put the month data (i.e. Feb, March ...) in the Value data the system count them as 1 whilst i dont want to have those data counted bu stacked. 

This is what i get for example for SABRE project, but those bars should be different based on the different end-date reported which in case of SABRE is April '20, May '20, Jun '20, Dec '20...

can you help me?