Delivery sheets - trying to make a report

[Empulak_cz]

Hello together,

since I'm new to PowerBI, I'd like to ask you for help with a report I'd like to create. 

I am retrieving data from SQL view that contains information about "delivery sheets". Each delivery list has a value in Euros, a delivery note designation and a delivery status ( delivered, undelivered, closed etc ). 

What I'm missing is the date of the "delivery notes" - basically I don't know when the new delivery note line appeared in the DB. 

What kind of report would I need?

I would need to compare data on a weekly basis. I'm interested in the value of all delivery tickets in weeks.

Can anyone direct me on how I can achieve this?

The main problem I see is that I don't have data on dates

Thanks a lot.

[Anonymous · Accepted solution]

Hi  @Empulak_cz ,

Is it possible to have data with a date column in the source data, and it will be automatically displayed after being loaded into power bi.

Or create a calendar table using dax:

If your data has date columns, I created some data:

Here are the steps you can follow：

1. Create measure.

Measure = CALCULATE(SUM('Table 2'[amount]),FILTER(ALL('Table 2'),'Table 2'[year]=MAX('Table 2'[year])&&'Table 2'[week]=MAX('Table 2'[week])))

2. Result:

Please click here for the pbix file

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Empulak_cz]

There is a column with the date. But i cant relay on it because the dates can be in the future. 

Isn't there an option to add date and time information whenever I update the data. With each update and new date I would add the time and date to a new column. Where the date is already there, nothing would be added.

What do you think?

[amitchandak]

@Empulak_cz , if you do not have date, what column you have to check dates ?