Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Missing datapoints in date-based measure

I defined some DAX measures in Excel 2013 based on a facttable with dates linked to a date table.   All measures correctly show their value by month (from the date-table) in a Powerpivot. I import ...
  • Anonymous's avatar
    Anonymous
    10 years ago

    I found the issue: the date table in Excel was corrupt. I could only select the columns in the fact table as unique identifiers for the date column (?)

     

    Rebuilding the date table from scratch solved the problem.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

I model the join with a date column already in Excel and just import to Power BI Desktop. Just checked there: still using that column with data/time format.

 

Interesting for me is to see that behavior already on the Excel side: Powerview does not plot the measures either. Only the Powerpivot table shows it correctly.

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

Well I guess it is either a bug, or it isn't. The challenge is to find out which. I would be happy to take a look if you can share with me. You can contact me via my website http://xbi.com.au or you could log a bug with MS

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    I found the issue: the date table in Excel was corrupt. I could only select the columns in the fact table as unique identifiers for the date column (?)

     

    Rebuilding the date table from scratch solved the problem.