Forum Discussion
Power BI DAX formula
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:
1 Reply
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