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 everyone!
I need to add a new data in my Dashboard, the sales targets by category (office and Horeca goals), I want to compare the orders vs Goals for Month and MTD. I have tried two options without success.
1.- New Column. I have tried adding a new column in the same table with the condition option "if the month of the year is 1 then it corresponds to X". The result is the sum of all rows (several) of the month, this is false.m
2.- New Table: I have uploaded the following table, the problem appears in the relationships.
Goals can be calculated by day or by month. The problem I don't understand is that in the "data orders" I have different rows with the same day.
Can anybody help me?
Thank you very much.
Solved! Go to Solution.
@MontsePuig,
Create a date table following the instructions in this blog, then create the following columns in your original table.
Column = CALCULATE(SUM(Table[Orders]),ALLEXCEPT(Table,Table[HOvsOF]))
MTD = TOTALMTD(SUM(Table[Orders]),'Date'[Date],ALLEXCEPT(Table,Table[HOvsOF]))
If the above steps don't help, please share sample data of your original table that can be copied and pasted, also post expected result in table format.
Regards,
Lydia
@MontsePuig,
Create a date table following the instructions in this blog, then create the following columns in your original table.
Column = CALCULATE(SUM(Table[Orders]),ALLEXCEPT(Table,Table[HOvsOF]))
MTD = TOTALMTD(SUM(Table[Orders]),'Date'[Date],ALLEXCEPT(Table,Table[HOvsOF]))
If the above steps don't help, please share sample data of your original table that can be copied and pasted, also post expected result in table format.
Regards,
Lydia
Lydia,
Thank you very much.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |