HELP WITH A DAX FORMULA

[E12]

I want to use this Logic to get opening Balance but its always returning Blank, any ideas on how i can resolve this. same logic is working well on Excel.

Opening Bal =
CALCULATE(
COUNTROWS('Data'),
(
(Data[Release Date] = BLANK() && Data[Request Date] < Data[Date]) ||
('Data'[Release Date] > Data[Date] && Data[Request Date] < Data[Date]) ||
('Data'[Release Date] = Data[Date] && Data[Request Date] < Data[Date])
)
)

[Anonymous]

Hi @E12 ,

To troubleshoot the problem further, please provide us with more information such as relationships between your tables and files to test .

Please make sure not attach sensitive data before sharing the files.

If you are unsure how to upload data please refer to 

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided

Best regards

Albert He