Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi to all,
I'm newly in PBI and was trying to do my best working on solution but I gave up for this moment.
I have to tables:
TABLE A (date|prod|value)
2019-01-01 | prod A | 300
2019-02-01 | prod B | 100
TABLE B (prod|year|month|value)
Prod A | 2019 | 1 |30
Prod B | 2019 |2 |22
Now this values of month (300 and 100) I'd like to use count an average for PROD_NAME by MONTH, i.e.:
for PRODUCT PROD A, month 1 = 300 / 30 = 10 AVG
for PRODUCT PROD B, month 2 = 100 / 22 = 4,54 AVG
I would be greatfull for any help and tips.
All the best!
Solved! Go to Solution.
Hi @MarcinSV,
I would suggest you create two tables. Then everything will be easy and clear. Please download the demo from the attachment.
Best Regards,
Does anyone has an idea how to solve it?
I will ask in different way (without product), maybe then I will find by myself the rest solution.
How to divide one value in month (table A) by second value (from different table, B) but exactly for the same month like in table A?
For example:
Table A: in December 2018 value = 300,
Table B: in Decemeber 2018 value = 30
So 300 / 30 = 10
Now I have one measure: Average of working day = SUM(Table A [Sales]) / 22 -> and I need to change this 22 to dynamic, depending on month /year value from table A and put in this place value from the same month/year but from table B. Now I have no idea how to change it using DAX that value from A will "choose" value from B...
Hi @MarcinSV,
I would suggest you create two tables. Then everything will be easy and clear. Please download the demo from the attachment.
Best Regards,
Thank you very much, now it works great!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |