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.
Hi,
I have this data set and i want to create a third column called Difference like (3.10-2.70 = 0.4 )so that i could place it on the geographical chart. Could anyone help me with the Dax calculation required for the same.
Solved! Go to Solution.
Hi @yashdsin,
If you want to calculate the difference for the product per month, you could create the calcualted columns below.
Please note that you need to change the data type of Index column to be whole number after creating it.
Index = RIGHT('Table'[Sales],1) Difference = VAR a = CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) - 1 && 'Table'[Date] = EARLIER ( 'Table'[Date] ) ) ) RETURN IF ( a = BLANK (), BLANK (), a - 'Table'[Value] )
Then you could create the matrix like below.
PS: We cannot achieve the same output as that in excel.
Hope this can make sense.
Best Regards,
Cherry
Hi @yashdsin ,
Have you solved your problem?
If you have solved, could you share the solution or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly?
If you still need help, please share your sample pbix so that we could help further on it.
Best Regards,
Cherry
No, Actually i need to see the diffrence between two cells Subtracting Product1 & Product2 in cell B2 & B3 i should be getting results in Cell B4 and so on for all the columns C, D, E etc but i am getting it as a whole for Product1 & 2 respectively as a total which is not required. Please help as i am still a learner.
Hi @yashdsin,
If you want to calculate the difference for the product per month, you could create the calcualted columns below.
Please note that you need to change the data type of Index column to be whole number after creating it.
Index = RIGHT('Table'[Sales],1) Difference = VAR a = CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) - 1 && 'Table'[Date] = EARLIER ( 'Table'[Date] ) ) ) RETURN IF ( a = BLANK (), BLANK (), a - 'Table'[Value] )
Then you could create the matrix like below.
PS: We cannot achieve the same output as that in excel.
Hope this can make sense.
Best Regards,
Cherry
Hi @yashdsin ,
It seems that you want to calculate the difference between the two values.
Normally, we could achieve that with three ways. You could choose the way based on your requirement.
1. Create the custom column in query editor ( columnA - column B)
2. Create the calculated column with dax ( columnA - column B)
3. Create the measure with dax.
If you still need help, please share your data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
Hi @yashdsin ,
Sorry for the delay.
You could upload your data sample or pbix in OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Cherry
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |