How to calculate the difference between two rows of a single column in power BI
Hi, How to calculate the difference between buy and sell of a salesvalues coulmn based on country by converting to rows to column of buy_sell column . Input: Country category buy_sell salesvalues India A buy Null India A sell -75,500.00 USA B buy -60,095 USA B sell 70,901 AUS C buy 29,923 AUS C sell -3,260,307 AUS D buy -60,750.00 AUS D sell -1500 USA E buy 10 USA E sell 20 USA F buy -20000 USA F sell Null Expected Output: Thanks, SBC
DAX mesaure : calculation of a value according to a measure
Hello everyone, Today I am asking you about a DAX measure. Indeed, for the calculation of a measure I need a variable. This variable is the turbidity value when the trubidity frequency in% between 0.20% and 0.21%: The frequency calculation is a measure, here is the code: Here is the code for the turbidity measurement: What is the formula to fill in for the calculation of this variable please? Thanks in advance, Joel
