Forum Discussion

bvy's avatar
bvy
Helper V
1 year ago
Solved

Adding Measure extends X-Axis...

See below. This project is a distillation of a greater project, so please no out of the box solutions -- such as using visual calculations, visual level filters, or the Analytics features. The soluti...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    your data model is the wrong way round.

     

     

    Dates should be the dimension table and "Table1" the facts table.

     

    Then do what Ashish_Mathur suggested.

     

    Why is the dark line supposed to be straight? It's an average over 30 days.  

     

    By the way, you can do that much simpler with Window functions.

    30DayAvg = CALCULATE(AVERAGE(Table1[Reading]), WINDOW(-29,REL,0,rel,ALLSELECTED(Dates[Date])))

     

     

     

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi bvy ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.