Forum Discussion

rohitchouhan's avatar
rohitchouhan
Frequent Visitor
6 years ago

Adding a date column

I want to add a new column as a date index, which starts with 03 April 2018 or any particular date and goes on till the current date. how to add this thing through DAX as a column.I got some DAX exp...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi rohitchouhan ,

 

 

Your requirement is not very clear.

 

Do you want an index column against the date. i.e 1 for Dates 3rd April, 2 for Dates 4th April and so on.

 

If so, please see this  https://community.powerbi.com/t5/Community-Blog/Getting-Previous-Values-in-Power-BI-Part-1/ba-p/1143370

 

Go to the section for creating a index column using rankx.

 

 

Regards,
Harsh Nathani

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

rohitchouhan's avatar
rohitchouhan
Frequent Visitor
6 years ago

Hello, thanks for the prompt reply,
i just want to add a column in my current table which starts from a particular date and goes on till today's date.
just like the calendar.I used some DAX but all those creating a separate table, not adding column to expecting table

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI rohitchouhan 

     

    Create an Index Column in Power Query.

     

     

    Regards,
    Harsh Nathani

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