cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shubs Regular Visitor
Regular Visitor

Comparison between selected months/days/quarter/year/weeks with prior period

Hello Everyone,

 

I have researched so much for this and found many solutions, but none worked for me. Please help me resolve this.

 

I have a single table with date column, sales, client name, location etc. Now i want if i select 2 months( let say Feb 18 and Mar 18) so i want to know the sale of selected period and prior 2 months sales in other calculated measure( ie Jan 18 and Dec 17 in this case). Similarly if I select say 7 days from now, so i want 7 days sales before the selected period. So i want to do that comparison and also if I select, let say a client after selecting a date period, so then i want the sales of that client in the selected period with the same prior period.

 

So if i select paricular days range, so I want sales of same prior days range and if i select months range, so I want prior month range sales.Similarly for every range I select.

 

I have only one table with dates repeating but it is continuous as sales transaction happen daily.

 

Please help me with this. I will be really thankful.

 

Thanksnee

2 REPLIES 2
Community Support Team
Community Support Team

Re: Comparison between selected months/days/quarter/year/weeks with prior period

@Shubs,

 

You may take a good look at this discussion.

http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Shubs Regular Visitor
Regular Visitor

Re: Comparison between selected months/days/quarter/year/weeks with prior period

@v-chuncz-msft

Thanks for the reply..But this solution wont help my scenorio..

A user can select anything from the date filter(i will be giving between Date filter), So I want the prior sales data based on the selection. I just dont want cards, I want these to be in a table with all other columns(like name, location etc) and want the prior calculation changes accordingly.

 

If need more explaination, Please let me know.

 

Thanks