Solved: Date Table Question

Anonymous · ‎10-13-2022

Hi,

I have created a Date table - see picture below:

Now, I would like to add numbers - and I have used the formula I am showing. However, it is a multi-year date table from 2017-2024. So, naturally January 2017 should be #1. However, January 2018, 2019 and so on also get the #1. I would like January 2018 to be #13.

Is anyone capable of helping with this?

Jihwan_Kim · ‎10-13-2022

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

View solution in original post

Jihwan_Kim · ‎10-13-2022

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page