topic add % change of units in each load time. in DAX Commands and Tips

add % change of units in each load time.

JalalMirahmadi — Fri, 19 May 2023 03:34:09 GMT

We are are trying to see % change of each load time side by side and add it to this visual , aslo would like to have option to choose two load times to compate too .
example :want to comapte load tme of 5/18/2023 to 4/24/2023.

All data coming from one data set and no measures has been used.

Re: add % change of units in each load time.

FreemanZ — Sat, 20 May 2023 07:44:19 GMT

hi JalalMirahmadi

Not sure if fully get you.

Supposing you have a data table like:

try to

1) plot a slicer with a calculated table like:

slicer = VALUES(data[Date])

2) plot a table visual with class column and a measure like:

measure = CALCULATE( SUM(data[Value]), data[Date]=MAX(slicer[Date]) ) - CALCULATE( SUM(data[Value]), data[Date]=MIN(slicer[Date]) )

it worked like:

Re: add % change of units in each load time.

JalalMirahmadi — Fri, 02 Jun 2023 15:12:02 GMT

FreemanZ Thank you for reply, to explain more and be more clear :
I want to create the below table in Power BI Matrix, so I have week number and Qty , then want to use dax to create unit variance and % variance .

wk 20	V U	V %	wk 21	V U	V %	wk 22	V U	V %	wk 23	V U	V %	wk 24	V U
60	0	0%	70	10	17%	45	-25	-36%	1	-44	-98%	200	199