Show after selected date the last 2 Month, last 4 week, last 5 workings day in diffrent visuals

[BileMG]

Hi,  

i am new in Power Bi and it is a powerful Tool but for me at the beginning a little bit difficult.

I want to create a Report drp feveloping my skills in PowerBi and at first i want to build Reports that we currently have in other tools.

At first i want do develop a Daily Report, that shows the Sales of the diffrent Sales Agent. The Report should show, after selecting the current or an indivduall date, the figures of the last 2 Months, the last 4 Weeks, and the last 5 Days in diffrent visualisations.

Like This

Have anayone an Idea how I could do this ?

BG

Michael

[v-yuezhe-msft · Accepted solution]

@BileMG,

Please review the following blogs about how to calculate last 2 months and 5 days sales based on slicer selection, use the same logic to calculate last 4 weeks sales.

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...
https://www.kasperonbi.com/show-the-sum-of-sales-for-the-last-3-days-based-on-date-selection/

Regards,
Lydia