Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community,
I would like to do one thing in Power BI.
Each month I get the investments and the year-end projection updated.
I have the 2 tables below (one for data and one for target)
| Invest | Landing |
January | 100 | 1200 |
February | 200 | 1200 |
March | 300 | 1300 |
Targets are entered in advance for the entire year and so I have all the values for the months
| Target |
January | 100 |
February | 200 |
March | 300 |
… |
|
September | 1200 |
I would only to show the landing point at end of exercice for the last month of exercice (september). What I want represented is this :
| Invest Display | Landing Entry | Target Display | Landing Display |
January | 100 | 1200 | 100 |
|
February | 200 | 1200 | 200 |
|
March | 300 | 1300 | 300 |
|
… |
|
|
|
|
September |
|
| 1200 | 1300 |
I'm a rookie and I can't get the graph I want.
Your help will be welcome!
Thanks in advance.
Do you have a relationship defined between the 2 tables (probably on the month column) ?
Help when you know. Ask when you don't!
Hello, yes i have a relanshionship by date in the calendar tab.
I have succeeded to create a line for landing by the formula
=calculate(claculate(sum(Data[Value]); filter(Data; and (Data[Date]=MAX(Data[Date]);Data[KPI]="Invest")));allselected())
Thanks for your help
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |