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.
For example i have 4 tables;
Table1: CurrentPeriod:
In this table there is only one record and this record is the current period of periodrange:
ID: 30050
Year: 2019
Week: 50
Table2: Periods
In this table all periods are stored:
ID: 30001
Year: 2019
Week: 1
ID: 30002
Year: 2019
Week 30003
en so on...
Table3: Revenue
In this table all the revenue by week is stored:
PeriodID: 30001
Revenue: 8000,-
PeriodeID: 30002
Revenue: 8500.-
and so on...
Table3: RevenueGoal
In this table all the revenue goals by week are stored:
PeriodID: 30001
Revenue: 7800,-
PeriodeID: 30002
Revenue: 8300.-
and so on...
I would to show an graph with
So far so good, but i will show all weaks of the year. We have a graph with the RevenueGoal for whole 2019 but we have none realisatin for whole 2019. It is posible by selecting all the weeks of the year. But I also will show the Revenue of the Current Period.
So I want to add a filter that wil sum de Avanue where PeriodeID of the AvenueTable is equal tot the periodID of the CurrentPeriod Table. Is that possible?
Solved! Go to Solution.
Hi @michielkuiper ,
I have created two measures as below to work on it. Please check the pbix as attached.
YTD =
CALCULATE (
SUM ( Revenue[Revenu] ),
FILTER (
ALL ( Period ),
Period[Year] = MAX ( CurrentPeriod[Year] )
&& Period[Week] <= MAX ( Period[Week] )
&& Period[Week] <= MAX ( CurrentPeriod[Week] )
)
)
this week =
CALCULATE (
SUM ( Revenue[Revenu] ),
FILTER (
Period,
Period[Week] = MAX ( CurrentPeriod[Week] )
&& Period[Year] = MAX ( CurrentPeriod[Year] )
)
)
Hi @michielkuiper ,
I have created two measures as below to work on it. Please check the pbix as attached.
YTD =
CALCULATE (
SUM ( Revenue[Revenu] ),
FILTER (
ALL ( Period ),
Period[Year] = MAX ( CurrentPeriod[Year] )
&& Period[Week] <= MAX ( Period[Week] )
&& Period[Week] <= MAX ( CurrentPeriod[Week] )
)
)
this week =
CALCULATE (
SUM ( Revenue[Revenu] ),
FILTER (
Period,
Period[Week] = MAX ( CurrentPeriod[Week] )
&& Period[Year] = MAX ( CurrentPeriod[Year] )
)
)
If possible please share a sample pbix file after removing sensitive information.
Thanks
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |