Week on Week difference in Graph

[GarethParry]

Hi,

Every week i get the current meter readings for a printer. The figures are cumulative. I want to work out how much is used each week.

I have created a measure which works perfectly in a table. Example for color copies used

colorprintdiff = SUM(t_print_monitor[colorPrint]) - CALCULATE(SUM(t_print_monitor[colorPrint]),FILTER(ALL(t_print_monitor),t_print_monitor[site] = MAX(t_print_monitor[site]) && t_print_monitor[deptId] = MAX(t_print_monitor[deptId])  && t_print_monitor[week] = MAX(t_print_monitor[week]) -1))

i want to show the week on week useage in a graph, but when i add the measure it jsut shows the cumulative figure.

is there a way of doing this?

thanks

Gareth

[FREDPI]

Hey, 

Best to work with a different data table.  A create a relationship. But it is possible with the same one

Like @Uzi2019  says, can you maybe share the datamodel 🙂

this is my test file 

MinConsumption = min(Sheet1[consumption])

MaxConsumption = MAX(Sheet1[consumption])

DiffConsumption = [MaxConsumption] - [MinConsumption]

Indeed should be min, was a bit to fast in ctrl+c/ctrl+v 

[Uzi2019]

hi @GarethParry 

can you share the sample data with expected output in excel.

It would be easier to understand your data model and your expected output.

[GarethParry]

Hi,

Slightly silly question, but how do i uplaod my excel file on here?

thanks

Gareth

[Uzi2019]

Hi @GarethParry 
you can share google drive public link or paste the excel data directly here.

just share the screenshot of your data like this 

[GarethParry]

did this help?

[GarethParry]

Hi

Data is

looking for graphs like (x axis is userid)

thanks

Gareth

[FREDPI]

Do you have a data table in your model?

I would suggets you add a datatable where weeks are attributes of that table.

After that I would create a measures

1) TotalPrinterMAX = MAX(t_Print_monitor[ColorPrint])

2) TotalPrinterMin= MAX(t_Print_monitor[ColorPrint])
3) PrinterColorUsed = TotalPrinterMAX - TotalPrinterMin

if you put on the x-axis the Week and on the Y-axis the PrintercolorUsed, you should get the desired result

[GarethParry]

Hi,

Hi,

Thanks for replying.

i already have the week number in the dataset. do you mean add a table that just has all the week numbers and create a connection between this and my dataset?

should 2) be MIN(t_Print_monitor[ColorPrint])?

thanks