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

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.
Shubs Member
Member

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 163 members 2,226 guests
Please welcome our newest community members: