question

JesperSteenJensen-1939 avatar image
0 Votes"
JesperSteenJensen-1939 asked HerbertSeidenberg-6295 answered

How to set a "Parallel Periode" of 'Is in the last 12 month' - using the Filter type: 'Relative Date' in Power BI

I link to a data source which give me monthly updated data from SAP.

The problem is, that these data are uploaded every 10th of a giving month, and last month of updated data are either 1 or 2 month older than present month (depending of the present date).

Since I use the 'Relative Date' filter function in all my reports, I would like the ability, to set 'is in the last 12 month' to a parallel 12 month period based on any giving present date.

I upload a table with only one variable which gives me, the 'Latest data period' for the data set I link to - together with my data sets, so that could be part of the solution ?

Example:

Today (May 4th) my dataset has data up till March. So I would like Power BI to filter my data based on the last 12 month up till March, witch mean - April till March - even though the present date is in May.

Can anyone guide me ?

Thanks

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered

Hi @JesperSteenJensen-1939,

Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums


(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)


Best regards,
Leon

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HerbertSeidenberg-6295 avatar image
0 Votes"
HerbertSeidenberg-6295 answered

Excel 365 Pro Plus with Power Pivot and Power Query.
Compare daily 2 month long data to same daily data a year ago.
With mostly PQ and no Time Intelligence Functions.
With Date Table.
https://www.mediafire.com/file/sih9mv7x0dh8xjm/05_31_21a.xlsx/file
https://www.mediafire.com/file/db6g72and0pnhos/05_31_21a.pdf/file

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.