Inventory Ledger

[guruvammal]

Qilk Expression : 

=if(Trans_Date < Date(FDATE,'DD-MM-YYYY'), 'OPENING', Date(Trans_Date, 'DD-MM-YYYY'))

In Power BI use date in between range is not coming to previous closing data in first row 

Which Dax used?

[Anonymous]

Hi @guruvammal ,

It's currently difficult to do this in the built-in table/matrix, and you can register ideas to help Power BI do it better here.
Welcome to Microsoft Fabric Ideas
Some paid custom visuals support inserting rows like this:
Insert row and manually enter data in Power BI matrix reports - Inforiver
You can also refer to this pattern to create another measure to output each new opening inventory.
Semi-additive calculations – DAX Patterns

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum