Forum Discussion

Angel's avatar
Angel
Resolver III
9 years ago

last date regardless context

Hi, everyone   Please, help!!!!!     The matrix is composed by:   Rows:         WeekCount --> Number of week regardless year (starts 01/01/2010)         Rel.Week --> Relative week respect...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Angel,

 

Based on my understanding, I think the formula below should work in your scenario.

MaxDate =
CALCULATE (
 MAX ( 'Dimdate'[Snapshot date] );
 ALLEXCEPT ( Dimdate; Dimdate[WeekCount] )
)

Or

MaxDate = CALCULATE ( MAX ( 'Dimdate'[Snapshot date] ); ALL ( Dimdate[Snapshot date] ) )

If that is not the case, could you post your table structures with some sample data? So that we can help further investigate on the issue. It's better to share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:

 

Regards

Angel's avatar
Angel
Resolver III
9 years ago

Hi, v-ljerr-msft

 

It works!!!!!!.... Thank you, master!!!!!

 

The last thing I want to do is only consider sales where sales date > max fecha. To do that, I have tried with this phormula..

Sales amount after max snapshot = CALCULATE(MAX('Sales registered'[Sales amount]);FILTER('Sales registered';'Sales registered'[Sales Date] > [MaxDate]))

However, as you can see in the image above It doesn´t work...

 

 

Any tip?