Variance % selected week- DAX

DKM_83 — Sat, 20 Jan 2024 07:13:26 GMT

Hi Team,

if I selecting a two week then i want to show the var% between the value.

Thanks,

Re: Variance % selected week- DAX

Jihwan_Kim — Sat, 20 Jan 2024 10:27:18 GMT

Hi, I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

INDEX function (DAX) - DAX | Microsoft Learn

Sales measure: = VAR _sales = SUM ( Data[Sales] ) VAR _weekselectcondition = COUNTROWS ( DISTINCT ( Week[Week] ) ) = 2 VAR _totalcolumn = NOT ( HASONEVALUE ( Week[Week] ) ) VAR _salesone = CALCULATE ( SUM ( Data[Sales] ), INDEX ( 1, VALUES ( Week[Week] ), ORDERBY ( Week[Week], ASC ) ) ) VAR _salestwo = CALCULATE ( SUM ( Data[Sales] ), INDEX ( 1, VALUES ( Week[Week] ), ORDERBY ( Week[Week], DESC ) ) ) VAR _percentage = FORMAT ( DIVIDE ( _salestwo - _salesone, _salesone ), "#0.00%" ) RETURN IF ( _weekselectcondition && _totalcolumn, _percentage, _sales )

topic Re: Variance % selected week- DAX in DAX Commands and Tips

Variance % selected week- DAX

Re: Variance % selected week- DAX