Forum Discussion

peraleonardo's avatar
peraleonardo
New Member
2 years ago
Solved

Newbie with a problem understanding code.

Hello everyone, I have been selected for an internship with a large company, and in this role, I am reviewing and studying the Power BI project that the corporate office has sent to our location.   ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, peraleonardo 

    Thank you very much for your reply. This is true if you intend to take all dates into account in your calculations without taking into account any filters applied elsewhere in the report. 

    ALL ( 'table'[date])

    However, if you wish to keep some filters, you may need to adjust this part of the formula. You should try using ALLEXCEPT to keep the other filters in your matrix.

    ALLEXCEPT function (DAX) - DAX | Microsoft Learn

    KEEPFILTERS function (DAX) - DAX | Microsoft Learn

    It would be helpful if you could make some virtual data and describe the output that you are looking forward to, it would help me understand your problem.

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

xifeng_L's avatar
xifeng_L
Super User
2 years ago

The MAX function in the code will automatically calculate the maximum date outside the corresponding date range.

 

xx = Calculate (

  Sum('table'[y]),

  FILTER

   ( ALL ( 'table'[date]),

     'table'[date] = MAX('table'[date]) && 'table'[date] <= TODAY()

))

 

Not quite sure if I misunderstood your question.