Power BI DAX formula

[Anonymous]

Hi Experts

i am trying to write last year's actual volume dax expression as below. However, it show total last year's data could not drill down to month and week. can anyone help? Thanks.

LY Vol =

VAR lyAct =

calculate (

    [Vol],

    ALL(dim_date),

    dim_date[fiscal_year_number]=FORMAT(MAX(dim_date[year])-1,"####")

)

return

lyAct

Layout:

[v-shex-msft]

Hi @Anonymous ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng