Multiplicar valores entre fechas
buen dias para todos agradezco su ayuda con una consulta necesito replicar una tabla de excel en BI el cual multiplica un valor de mayo por un valor de junio, pero no encuentro la manera de hacerlo, agradezco su ayuda si conocen una forma de lograr el calculo, muchas gracias!! adjunto imagen de la tabla que esta en excel y el calculo
Multiplying Single Values by A Measured Column Total in Table
I have numeric values (1,2,3,4,etc) in one column, and I want to multiply each of these values by the total of a different, measured column. Is this possible within Power BI? For example, in Power BI, I utilized the distinct count formula to give me the distinct count of shipments ( "Distinct Count (Y)" ). I also have basic column that gives me the total cost of that shipment ( "X" ). Then, I created a measure that divided Total Cost by the Distinct Count of Shipments ( "X/Distinct Count (Y)" ). Now, I have another column that has difference in the distinct count of shipments between this month and last month ( "Z" ). My goal is to multiple each of the values in "Z" by the total of "X/Distinct Count Y". The total of "X/Distinct Count Y" is basically the overall average cost per shipment. Hope this explanation helps. I created this example in excel to visualize what I am looking to accomplish.
