Forum Discussion

Cmuglioni's avatar
Cmuglioni
Frequent Visitor
4 years ago
Solved

SAMEPERIODLASTYEAR - Total Problem and Partial Solution

Hi Everyone,   Let me explain my issue: I am looking to have the amount of wine cases (#Cajas) of the same period last year. Of course I used the following Dax Sentence and it works fine with detai...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Cmuglioni , Power bi recalculate, grand total. As there is no date selected. It is 1 year behind the measure of the duration available. I think it is summing up everything before 1 year from the end date of the calendar in the grand total. The other one forces a range. so it is working in that case

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Cmuglioni , Power bi recalculate, grand total. As there is no date selected. It is 1 year behind the measure of the duration available. I think it is summing up everything before 1 year from the end date of the calendar in the grand total. The other one forces a range. so it is working in that case

Cmuglioni's avatar
Cmuglioni
Frequent Visitor
4 years ago

Hi amitchandak, indeed, I think my issue is coming from the fact that there is no date selected. My Calendar Table has a daily update and everytime I update my report I don't have a selected value because I am considering the all universe of dates available. Is there a way to automatically select the last date in order to make the time functions work?