Sample Query by Dates

[Kane]

Hi, PowerBI experts,

I would like to sample my query (such as SUM(Project[Progress])) by date and create a visual of "SUM(Project[Progress])  vs. the date" as below.

i am wondering where to store the sampled values and how to generate the visual with DAX formula ?

THANKS !

Best Regards,

Kane

[ImkeF]

Have a look at the very good documentation here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-measures/

[Kane]

Thank you Imke !

Acctually, I have read most of the documentations of "PowerBI Desktop" and "PowerBI Service", and got a basic knowledge of the measures and formulas.

My question is that how to sample a query automatically by dates (not a Date collum in the query) and then creat a visual with the sampled values.

THANKS !

Kane

[ImkeF]

Sorry, but I don't understand what you mean with "sample by date": You need a column that for your axis.

How should the dates there be different from the "Date column in the query" that doesn't suit your needs? Could you please provide an example for it?

[Kane]

Hi, Imke,

Let's see a very simple case.

Suppose we have a project which was assigned to four persons (A,B,C,D). Each of them shares parts of the total tasks.

We use the following Excel table located in the Onedrive for Business to track the progress of the whole project.

All of the four persons are asked to update their progress into the Excel table everyday.

Therefore, we can easily transform the data to several simple PowerBI visuals, based on which we can read the latest progress of each person, as well as the total progress of the project.

However, we need not only "the latest progress", but also the trend of the progress. So, we need a PowerBI visual which will records the progress of yesterday, today and each of the following days. In other words, we want to create a visual whose Y-Axis is the "progress value" and the X-Axis is the "real Date".

We know that the Excel table will be updated by the four persons and contains only the up to date values.

So, my question is: how could I "record" (or "sample") the latest value every day so that I can transform them into a trend chart as below?

THANKS !

Best Regards,

Kane

[ImkeF]

Oh I see - sorry, English is not my native language.

Here you go: http://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-...

Just take a simple date instead of datetime like in my article.

[Kane]

thank you Imke ! I will try your solutions !