Measure is showing dates which are not in my Calendar table

[PeterStuhr]

Hi!

I have a strange behaviour, where a measure is showing dates which are not in my Calendar table.

My calendar table is based on dates from sales FIRSTDATA and LASTDATE (meaning last date is today).

My Measure "PPW_jumpstart" is simply dividing 2 numbers:

PPW_Jumpstart = DIVIDE(SUM(Turnover[Price]),SUM(Turnover[Minutes])).

How can I avoid this? Even if I filter it to 2021-03, it still shows full 2021?

[v-luwang-msft]

Hi @PeterStuhr ,

Have you solved your problem? 

You can upload the .pbix file to onedrive business and share the link with me.

[Anonymous]

Is it possible for you to share pbix file ?

[PeterStuhr]

Hi, sure, how do I share? Can not link it here

[Anonymous]

Use google drive or dropbox. No way to directly attach the file here.

[PeterStuhr]

Hi

https://www.dropbox.com/sh/qc12jzgqjk5j2qm/AACT5KAF-fGh5l9Lr_Ok-0yZa?dl=0

[v-xulin-mstf · Accepted solution]

Hi @PeterStuhr,

Date Hierarchy   showing all dates of the year , you could try the following solutions.

Solution 1,

Create a new column base on  LTM_PPW_Actual

ltm_PPW2 = [LTM_PPW_Actual]

then you will get the below:

Solution 2,

Use  Year and Month as  rows ,not date

Wish it is helpful for you !

Best Regard

Lucien