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.
Im currenly having an issue with VAR data. When i try to run this with all that dax measurements i run out of memory. As you can see i only have 7 measurments in this because i couldnt figure out which measurement was causing me the issue. Unfortunately, its this one. Does anyone know of a diffrent way of attiving this? basically i want to subtract the previous dimension with the current dimension. these are based on time stamps. so in excell it would be =ABS ( A2-A3). Something like that but because power bi is not set up like this i had to make another equation basically to get the dates in order (which is the second picture). I cant imagine this is that big for power bi which leads me to believe that its how i wrote the DAX measurment.
Any help would be appreciated
Sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Unfortunately, I cant post the actually data due to privacy issues nor can i give you the actual file that im working with. I undertand how that would make it eaiser to answer my question. Apologize for the little information to go off of.
Moving Range =
IF (
ISBLANK ( 'eOVL Data - MySQL'[Earlier Time1] ),
BLANK (),
(
VAR EarlierTime =
CALCULATE (
MAX ( 'eOVL Data - MySQL'[TimeStamp] ),
FILTER (
ALLSELECTED ( 'eOVL Data - MySQL'[TimeStamp] ),
'eOVL Data - MySQL'[TimeStamp]
< SELECTEDVALUE ( 'eOVL Data - MySQL'[TimeStamp] )
)
)
VAR EarlierMeasureValue =
CALCULATE (
SUM ( 'eOVL Data - MySQL'[Measured Value] ),
'eOVL Data - MySQL'[TimeStamp] = EarlierTime
)
RETURN
ABS ( EarlierMeasureValue - SUM ( 'eOVL Data - MySQL'[Measured Value] ) )
)
)
This should now be a proper dax equation. All selected is becasue i have slicers that need to be used. I know this will slow down Power bi also but i need the. Basically there is thousands of part numbers that this is looking through and the time in which they were measured. Its let putting them in order from oldest to newest. Its then getting the diffrence between measurments. If your familiar with stats, its a moving range chart. The equations that i use work when the data that is pulled isnt huge but when I pull from our SQL database instead of an excel workbook it takes 20 min.
Oh, and there is a date table you just couldnt see it in the Snip-it that was sent.
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 |
---|---|
48 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |