Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |