Help with P3M, P6M & YA Sales - Time Intelligence

[MiguelCruz]

Hi to everyone!

I am trying to do this in PBI but i’m having problems with the formulas. Looks very simple but it can’t do it

The table i want should look like this in PBI:

I’m attaching the PBI file and also the data in excel. Hope u can help me.

Thanks EXAMPLE FOR ENTERPRISEDNA.pbix (163.3 KB) FILE EXAMPLE.xlsx (222.5 KB)

[Harsh]

Hello @MiguelCruz,

Thank You for posting your query onto the Forum.

Just wanted to check that will the PM and YA be the normal total sales or they’ll also be considered as an average sales of past month and year ago like you’ve specified for the P6M and P3M?

Thanks and Warm Regards,
Harsh

[MiguelCruz]

Hi @Harsh for PM and YA it should be just the sum of the sales.

Thank you

[ells]

Hi @MiguelCruz

Might be worth a look at this page. Plenty of patterns and a good description.

Dax Patterns Standard Time Calcs

E

[MudassirAli]

@MiguelCruz
It is recommended to have a full Date Table

Extended Date Table (Power Query M function)

Hi everyone, To make it easier to find I’ve placed the updated Power Query M code function for the extended Date Table / Dates Table in the category where it belongs… I hope you’ll find it useful and if there are any questions, just reach out and let me know! // August 2022 There has been an overhaul of the M code from when it was initially shared. This affects column names and values. In the Analyst Hub (follow this link) you can copy a version of Extended Date table which returns a r…

Secondly, Mark your Dates as Date Table.

Thirdly, align your Dates in Date Table with the Dates in the Sales Data.

After these adjustments try to get the results and if you face any problems, you can always reach out to us.

Thanks.

[EnterpriseDNA]

Hi @MiguelCruz, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!