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'm having some trouble coming up with a measure. I have a report that I refresh with new data at the beginning of each month. This new data contains changes to the old daata and new information for the previous month. IE. It's currently August 1st - so I'll replace the data with a new table that contains July data as well as changes to other months data. There will be no data relating to the current month I'm in.
I'm trying to set up a matrix to show the data as of June 31st compared to the data as of July 31st. The columns are the measures as follows: Data as of June 31st, Data as of July 31st, difference between the two, percent difference.
To show the data as of June 31st I have a measure written as:
You have to have a relationship defined between the tables. It looks like currently you don't. Hence the filter under CALCULATE has no effect on the calculation.
All of the tables in this report are related. I am also using a Date Dimension table which is where the filter is pointing to.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |