Forum Discussion

CarlBlunck's avatar
CarlBlunck
Icon for Resolver I rankResolver I
3 years ago

Trending headcount

Hi all,   I've written the following dax expression to calculate a trending headcount but it is consistently giving 1 less than what the result should be.  Example, result for March 2022= 10,245 bu...
DAX
Anonymous's avatar
Anonymous
Not applicable
3 years ago

The measure seems correct to me. Are you sure this isn't happening because of the way the data is imported in Power BI? 

  • CarlBlunck's avatar
    CarlBlunck
    Icon for Resolver I rankResolver I
    3 years ago

    I was wondering that - I noticed that when the data is refreshing it says there are 69,883 rows.  But when I look at the table after the refresh in the data view, it says there are only 25,737 rows, which I find weird...

    Table in the data view matches what I am seeing in SQL.