Forum Discussion

Vatz8's avatar
Vatz8
Icon for Helper I rankHelper I
3 years ago

SUMX Calculation

  Hi,  I am trying to add consecutive punch hours in consecutive hours column  if the difference between the current row and the previous row is less than 1.5. I have already added an index column ...
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

First, you should refrain from using

Use variables instead. Please go to EARLIER – DAX Guide and peruse the article. Then change your code accordingly.

 

Also, please refrain from using one-table models. Such a (bad) practice will create so many problems in no time that you'll be forced into doing it the right way anyway (and will be wasting time). Please read about how to create correct models that in fact do calculate what you want them to instead of giving you - RANDOMLY - wrong figures: Understand star schema and the importance for Power BI … (bing.com)

Vatz8's avatar
Vatz8
Icon for Helper I rankHelper I
3 years ago

Hi, 

can you please provide a solution to this problem?