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.
Hello Guys!
I know these are dumb question but I'm totally new here. Please bear with me, I'm sorry.
Ok so I have these products below and I want to create this table.
Table: Product
Product Name | Total | Calculator | Charger | Cable |
Calculator | 6 | 3 | 5 | 2 |
Charger | 12 | 2 | 4 | 2 |
Cable | 7 | 1 | 3 | 3 |
I have this query:
Product Name | Total |
6 | |
Calculator | 3 |
Charger | 2 |
Cable | 1 |
I just want to put the TOTAL amount in to the second row in Total column. Also I want to filter these products by MonthYear and Branch. Do you guys have idea on how to do it? I could totally use some tutorials.
Again, Im really sorry for these dumb question and Thank you very much for your help.
Solved! Go to Solution.
Hello @Anonymous
this DAX-code will not provide any totals. To add the total put around the second parameter a ROLLUP-function. But anyway, in a database the position is not important, so there is no way to decide where the rollup is showing up, it's always put at the end. You could use power query to solve this.
About your second question, yes you can filter them by time dimension, but you have to have a column in your fact-table that showing a time reference.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello @Anonymous
this DAX-code will not provide any totals. To add the total put around the second parameter a ROLLUP-function. But anyway, in a database the position is not important, so there is no way to decide where the rollup is showing up, it's always put at the end. You could use power query to solve this.
About your second question, yes you can filter them by time dimension, but you have to have a column in your fact-table that showing a time reference.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
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.