Microsoft Lists Problem

[Yarisch77]

Hi Everybody,

I have a strange Problem, importing a Microsoft List into PowerBI.

I recently built a Microsoft List with calculated columns:

I use this column to get total processing time, using TODAY formula getting a number. The caluclation in Microsoft List works perfectly as shown in Microsoft Lists--> (Today (06.12.2022) - 21.10.2022 = 45 days:

Now, when I connect the List into a dataflow in PowerBI, it comes up with this value:

I didnt use any further JSON formatting in Microsoft Lists etc.

I just want to show it in PowerBI "45".

Any ideas about that? 

[v-jialluo-msft]

Hi  @Yarisch77 ,

According to your description, your problem is an error reading data in Microsoft Lists.

You can see if the following link helped you, or you can try this measure by doing date operations in Power BI:

DIFF = DATEDIFF(MAX('Table'[Date]),TODAY(),DAY)

Solved: Data values from a Microsoft List replaced by mult... - Microsoft Power BI Community

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.