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,
I'm trying to create the next view
In my model I have to compare two periods in a dynamic way
When in each period there are years, quarters, and months
For example, in the first period I choose 2016 in the second period 2017
In the table I should see the following result
[Sales2016], [Sales2017], [(Sales2016) - (Sales2017)]
How can the model be built to have independent Date tables and the data can still be compared?
Thanks.
@shimona there are other ways to compare data, what exactly are you trying to do?
for example you can derive previous year values or year - ? value..
what exactly are you trying to see by comparing 2 disconnected data sets, essentially they would need to be disconnected i would think otherwise they would filter the other
Proud to be a Super User!
thank you for the quick reply,
I need to compare a summary of two values that depend on the period
For example, the third quarter of 2015
Compared to 2017 Q1
(the selection should be dynamic)
And then calculate the ratio between them
The table should contain 3 columns
sumQ3_2015, sumQ1_2017,(sumQ3_2015 / sumQ1_2017)
How i create model with two calander table Without filtering each other.
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 |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |