Forum Discussion

Liz-m's avatar
Liz-m
Regular Visitor
2 years ago
Solved

Filter on date range, include multiple registrations made on the same date in count

Hi    I am trying to complete what I thought would be a super simple task, but can't find a solution that works!   I have a connected to a SharePoint List in Power BI that contains registrations,...
  • Liz-m's avatar
    Liz-m
    2 years ago

    Problem was caused by the date field in the SharePoint list which was initially built from an excel spreadsheet. Tried transforming date fields in Power Query, creating new calculated columns, measures, dax references etc but nothing would get the date field to behave correctly. 

     

    The only solution that worked was to create new date field directly in the SharePoint list and reinput the data. Now dashboard is behaving as it should be and calculating correctly. Luckily this is a small dataset.

Liz-m's avatar
Liz-m
Regular Visitor
2 years ago

Problem was caused by the date field in the SharePoint list which was initially built from an excel spreadsheet. Tried transforming date fields in Power Query, creating new calculated columns, measures, dax references etc but nothing would get the date field to behave correctly. 

 

The only solution that worked was to create new date field directly in the SharePoint list and reinput the data. Now dashboard is behaving as it should be and calculating correctly. Luckily this is a small dataset.