topic Giving ID to rows of dates in DAX Commands and Tips

Giving ID to rows of dates

Weegreen — Fri, 19 May 2023 06:40:14 GMT

Hi all,

Don't think this should be complicated but has me stuck! It is something I know I can achieve in PowerQuery but need the row numbers re-asessed based on slicer options so hence I believe it needs done as a DAX measure.

I have a list of dates which I need to order and rank as per pic, but when slicers are applied these numbers need to recalculate based on the range now available. There are duplicate dates in this list which need given numbers different to one another. The closest I have come is using RANX but whatever I get closed is aggregating dates that are the same. I drew a sketch for a friend as below (it is the 'Burndown' column I am trying to create), any help would be massively appreciated!!!

Re: Giving ID to rows of dates

some_bih — Fri, 19 May 2023 10:05:09 GMT

Hi Weegreen I am not sure what you need exactly, but if for part "There are duplicate dates in this list which need given numbers different to one another." you could in PQ insert index column (in my case starting from 1)

I created test data, so 10.5.2023 and 12.05.2023 are duplicate dates so first picture below is before slicing and second is for slicing one date 10.5.2023. I hope this help

Re: Giving ID to rows of dates

Weegreen — Mon, 22 May 2023 06:37:07 GMT

Hi some_bih,

Thanks for replying! If it helps clarify, what I mean by being re-indexed is in your first instance, the index would show 1 and 2. But in the second instance the index would show as it does in your photo. Does that clarify at all?

Thanks

Re: Giving ID to rows of dates

some_bih — Mon, 22 May 2023 09:17:30 GMT

Hi Weegreen I just saw that order of my picture should be reordered (1st should be 2nd lol). I still do not get your request. Maybe you should try my approach for start, with your data.

As I understand you need slice interaction, which is fine. Still, what is your input and wanted output? Give us some examples for input/output.