Opening Balances functions returns (Blank)

[Error1004]

Hallo guys,

All opening balances (Month, Quarter & Year) functions return (Blank) BUT:

• All other Time intelligence functions such as MTD, QTD, YTD & PY work fine.
• Date column in dimension & fact tables are type: Date
• Time dimension includes all dates

Time table & Time hierarchy structure:

Matrix visual:

Calculations:

• OB Month = OPENINGBALANCEMONTH(SUM(FctTransactions[Units Sold]),DimTime[Date])
• OB Quarter = OPENINGBALANCEQUARTER(SUM(FctTransactions[Units Sold]),DimTime[Date])
• OB Year = OPENINGBALANCEYEAR(SUM(FctTransactions[Units Sold]),DimTime[Date])

Any idea what I m missing? Any help will be greatly appreciated!

[some_bih]

Hi @Error1004 please share file to check details

[Error1004]

Hi @some_bih please find attached the files. 

https://www.dropbox.com/scl/fi/r626m91nalkh2vehgdu1q/Financial-Sample.xlsx?rlkey=ola0yml7k0ec05b3lqn...

https://www.dropbox.com/scl/fi/659as8yg47czj41vdxo1x/Test.pbix?rlkey=w2zyxf5ze8g99cbn8e6g74c98&dl=0

Have in mind that i have modify the calculation to use the date from the fact table and is wokring. However to dont manage to use the date from the dimension table.

[some_bih]

Hi @Error1004 try following: create measure

1. UnitSold_asMeasure=SUM(FctTransactions[Units Sold])

2. OB Month measure = OPENINGBALANCEMONTH([UnitSold_asMeasure],DimTime[Date])

[Error1004]

Hi @some_bih really appreciate your answer but i have also try this without any luck.