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.
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
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |