Forum Discussion

MH3's avatar
MH3
Helper V
5 years ago
Solved

Last Year Week Measure

Hellot, I need your help in fixing a Measure for a BI Report We have a client who uses Seasonal Calendar and which is different from the normal calendar Which Starts from May and End on Apri...
Need Help
Show and Tell
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi MH3 ,

     

    I think this is caused by the same number of Fiscal weeks from 2020-04-27 to 2020-05-03, try to add the month filter.

     

    Week Revenue LY = 
CALCULATE (
    SUM ( Bi_Turnover[Revenue] ),
    FILTER (
        ALL ( 'Date' ),
        'Date'[FiscalYearNumber]
            = max( 'Date'[FiscalYearNumber] ) - 1
            && 'Date'[Fiscal Week] = max( 'Date'[Fiscal Week] )
            && 'Date'[FiscalMonth] = max( 'Date'[FiscalMonth] )
    )
)

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

amitchandak's avatar
amitchandak
Super User
5 years ago

MH3 , if you have week and year in the context try like

 

Week Revenue LY = 
CALCULATE (
    SUM ( Bi_Turnover[Revenue] ),
    FILTER (
        ALL ( 'Date' ),
        'Date'[FiscalYearNumber]
            = max( 'Date'[FiscalYearNumber] ) - 1
            && 'Date'[Fiscal Week] = max( 'Date'[Fiscal Week] )
    )
)
MH3's avatar
MH3
Helper V
5 years ago

Hi amitchandak 

 

I have Season Slicer and Hotel Slicer in my Context


The Weekly Revenue LY Shows the Same Result for May 2021 which is 65,590, but the May 2020 has no Data, so it should not show this revenue, this revenue was in April 2020' Week #27

2021 May 




2020 MAY




The Weekly Revenue Should show Blank of May 2020 if the Week is Selected from 1st May 2021

The Issue is only in the 1st Week of May 2021 to its Previous May 2020