Use only full weeks in DAX

[Anonymous]

Hello peeps,

I have a quick problem. I have an external dateTable which I build for referencing.

Now I want to display data in line charts. By weeks, which looks like this:

I want the first and last week (in this case) to disappear. Simply, because there are not "full" weeks.

Since it is an "self-build" dateTable, I didn't find a workaround. In M this would be possbible, in DAX I dont know how.

All the best,

Julius

[v-xuding-msft]

Hi @Anonymous ,

You could try to change start and end of X axis in Format field. In this way, you don't need to create a formula.  Values will be shown as what you set.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

[Anonymous]

Hey Xue,

apparently it's not dynamic anymore then. Therefore as soon as week 42 is over and week 43 is ongoing, this line chart becomes useless or has to be adjusted manually..

[Anonymous]

Maybe there is a way to NOT show the last few days if the week in it is not full?

I hope I am not overcomplicating this matter..

@v-xuding-msft