Forum Discussion
ammeijs
5 years agoHelper I
Last row is missing from visuals
Hi all, While trying to fetch the last value or all the values from the selected period, still one row gets excluded from the visuals: the last row. - The dataset is just refreshed (from webconne...
- 5 years ago
Hi, ammeijs
Please download my file,don't modify it after opening it, and see if 11.24 appears.
You may have changed something, but it is not shown in the sample you gave. I noticed that your date table uses the date column in the third table, which may lead to incomplete dates when establishing a relationship with the second table.
You can try:
Kalender = CALENDAR(min(Persvragen[Datum]), max(Persvragen[Datum])) or Kalender = CALENDARAUTO()If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
5 years agoSuper User
ammeijs , check the datatype, it should be date.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.