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

[Anonymous]

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

[v-chuncz-msft]

@Anonymous,

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

[Anonymous]

@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