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've calculated the following measure:
DATEADD moves the actual daterange a specific interval. So if you have a matrix with a column dimension of month, you are essentially placing a month filter on that specific cell. When you apply DATEADD to the measure calculated in that cell it moves the range the specified amount.
So with no dateadd:
Jan-19 | Feb-19 |
Sales in jan | Sales in feb |
With dateadd -2 months:
Jan-19 | Feb-19 |
Sales in nov | Sales in dec |
If you want to display previous quarter, you need to make sure that the date table contains only the current quarter before you apply the dateadd to the column.
My advice is to do something like:
ALL(datetable),
Year = YEAR(TODAY())
Quarter = QUARTER(TODAY()),
DATEADD(datetable[dates],-3, MONTH)
Hi,
in my example I see the sales under thier respective month. So if current month is Jan I see previous month (Dec) under Dec, whereas I'd expected it to be shown under Jan as you said.
That sounds like you the issue is related to which dimension you are using in your table.
The month column that you are using as the column dimension, is it from your sales table or your date table?
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |