MTD is not working for 'new column'

[Maru]

I have spent hours but still can't figure it out what really happend.

MTD function work fine with normal column from data model, e.g. 'order quantiry' as calculated in mtd_qty.

But for a 'new column' filledIn, it returns unusual value in 'mtd_filledIn' 

Any suggestion I might have missed?

[Maru · Accepted solution]

Finally, it is just the way how Power BI display data in the table. I thought the table would display just like a raw table data. I didn't know that it must have a unique column.

Now, I change to display as 'sum' then it makes sense now.

[v-zhangti]

Hi, @Maru 

What results are incorrect? With the time you provide, what kind of output will you expect?

Best Regards

[Greg_Deckler]

@Maru I recommend avoiding DAX TI functions. If you post your DAX formula I can probably provide and equivalent.