Tag Archive: BLANK

BLANK() Function Not Working As Expected

Trying to handle blank values in Power BI… I needed a measure that would fill blank gaps across days where a value wasn’t present – I thought the BLANK() function would help me achieve this. My goal for the results of the measure is shown below: The logic is quite simple, if the value on that day is not blank, take that value. If it is blank then take the previous non-blank value. The first piece of logic is to get the date where…