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.
Hi All,
Need ur help in this.
We are using the Date dimention is our data model, Using this how can we drive the following:
Current Quarter
%change from last quarter
% change from last year same quarter
Thanks
Hi,
Create a Calendar Table and build a relationship from the Date column of the Data Table to the Date column of the Calendar Table. In the Calendar Table, create columns for Year and Quarter. Drag Year and Quarter to 2 slicers and select any one year and quarter. Write these measures
Total sales = SUM(Data[Sales])
Total sales in previous quarter = CALCULATE([Total Sales],PREVIOUSQUARTER(Calendar[Date]))
% change over previous quarter = IFERROR([Total Sales]/[Total sales in previous quarter]-1,BLANK())
Total sales in same period last year = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(Calendar[Date]))
% change over same oeriod last year = IFERROR([Total Sales]/[Total sales in same period last year]-1,BLANK())
Hope this helps.
Hi @Ashish_Mathur Ashish,
Many thanks for your reply.
I am using the below data model.
I should not any slicer for Year and Quarter. This should always work with current quarter and Last quarter and the result should be as :
Please guide me on this.
Thanks.
Hi,
Share the link from where i can download your PBI file.
Thanks for looking into it.
Unfortunately, i am not able to upload my file dure to large data size may be.
Would appreciate if you can provide your guidence based on the data model i have shared.
Many 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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |