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,
I need help with a measure. I'm trying to calculate the Starting revenue value for each quarter/period filtered.
I have the Q1 with V2 but then I have to apply the filter using ALLEXCEPT or ALL and then filter again ..
Expecting result:
Solved! Go to Solution.
I found the solution:
I found the solution:
Hi,
Share the link from where i can download your PBI file. When does your FY start? Do you have a Date column in your raw dataset?
Hi,
Share the link from where i can download your PBI file. When does your FY start? Do you have a Date column in your raw dataset?
Hi @Ashish_Mathur ,
I can´t share the file. And yes I have a date table:
I'm not sure why you need when date start. I don't want to hardcode the measure. The criteria should be that the start Q is the one that ends with 1.
That´s why I use VAR1 and VAR2 that defines the first Quarter of that point in time/period.
And with that I need to filter but not sure how to use ALLEXCEPT/ALL/FILTER, etc in that last part.
I will need data to work with. Anonymise the data, if feasible.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |