Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear all,
Coming back with another Question:
lets say i have the following measure :
ActualQTD = CALCULATE([Actual], DATESQTD(Calendar[Date]))
Can i calucle the QTD for More columns within the same measure? lets say actual is invoiced amount , but want it to calculate also pieces or tons without having to create another measure for each one:
Like below :
ActualQTD = CALCULATE([Actual], DATESQTD(Calendar[Date])) & CALCULATE([Pieces], DATESQTD(Calendar[Date])) & CALCULATE([ETC..], DATESQTD(Calendar[Date]))
is it a way around it as with & dont think it will work
Hi @alexbalazsalex,
Can i calucle the QTD for More columns within the same measure? lets say actual is invoiced amount , but want it to calculate also pieces or tons without having to create another measure for each one:
Like below :
ActualQTD = CALCULATE([Actual], DATESQTD(Calendar[Date])) & CALCULATE([Pieces], DATESQTD(Calendar[Date])) & CALCULATE([ETC..], DATESQTD(Calendar[Date]))
So what result will the measure finally return? QTD for [Actual]+[Pieces]+[ETC..]? QTD for [Actual]*[Pieces]*[ETC..]? Or anything else?
Could you be more precisely with requirement by posting some sample data and the expected result, so that we can better assist on this issue?
Regards
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |