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 have a problem with power bi Desktop. I have in a page 2 slicer (Year, Month) and a table that show project name, year, month, pianification period and value. Pianification period is a calculated column that for the month and year choosen in the slicer, it show current month, next month and next 2 months. If i choose from slicer year = 2019 and month = 11, PianificationPeriod show values 11 (current month), 12 (next month) and 1(next 2 month). But attention: this last value of PianificationPeriod must be of the next year (2020). My attended result is this:
PROJECT | YEAR (from slicer) | MONTH (from slicer) | PIANIFICATION PERIOD | VALUE |
P1 | 2019 | 11 | 11 | 123 |
P1 | 2019 | 11 | 12 | 456 |
P1 | 2019 | 11 | 1 | 789 (value of month 1 of 2020) |
The result obtained is this:
PROJECT | YEAR (from slicer) | MONTH (from slicer) | PIANIFICATION PERIOD | VALUE |
P1 | 2019 | 11 | 11 | 123 |
P1 | 2019 | 11 | 12 | 456 |
P1 | 2019 | 11 | 1 | 0 |
Here's my measure VALUE and my calculated column PianificationPeriod:
PIANIFICATION_PERIOD =
MEASURE_VALUE =
@Anonymous , your last row is sowing P1 2019. How come system know it P1 2020.
In case of custom, period create an incremental rank and use that to solve such cases
This period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[period Rank]=max('Date'[period Rank])))
Last period = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[period Rank]=max('Date'[period Rank])-1))
Nest 3 period Sales =
Var _min = maxx(allselected('Date','Date'[period Rank])
Var _max = maxx(allselected('Date','Date'[period Rank]) +3
CALCULATE(SUM(Sales[Net Sales]),FILTER(all('Date'),'Date'[Week Rank]>=_min && 'Date'[Week Rank]<=_max))
Thank you for you reply, but i don't want to use time intelligence for this case.
If the selected month is 11 and the pianification period is 1, i want to remove the filter on year and month to show value of another year and another month.. can i use function ALL to solve this?
We can't use time intelligence because we use the concept of Scenario (instead of year) and Period (instead of month). I used month and year in the first post to simplify the situation.
@Anonymous , all will remove all the filter. So better have your period in a different table and use all on that.
I think you can work with non-standard period using rank
In this blog, we already have incremental period no, so did not use rank
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |