Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  VIRTUAL TABLE

    Posted 12 days ago
    Edited by Kumar Kumar 12 days ago
      |   view attached
    Dear friends

    i'm having a problem to calculate the AGING balance; However i have 2 measures to calculate my aging stock and works fine with expected result (690). Whereas i wanted to merge this into one measure and i'm not getting the correct values 690 instead of 4679

    Please help me, how can i get correct value (690) instead of 4679
    Sample file attached for your reference

    ------------------------------
    Kumar
    ------------------------------

    Attachment(s)

    zip
    InventWorkings.zip   4.19 MB 1 version


  • 2.  RE: VIRTUAL TABLE
    Best Answer

    Posted 9 days ago
      |   view attached
    Olá

    Acho que não deu certo por que a variável não altera por ser estática. Troquei a variável _tdt por MAX(DimDate[Date]), e a variável _tmpAgeStk pela formula toda.






    ------------------------------
    Vilmar Santos
    ------------------------------

    Attachment(s)

    pbix
    InventWorkings.pbix   4.22 MB 1 version


  • 3.  RE: VIRTUAL TABLE

    Posted 6 days ago

    Thank you Vilmar Santos

    very much and this is what i was looking long time and i got relived



    ------------------------------
    Kumar Kumar
    ------------------------------



  • 4.  RE: VIRTUAL TABLE

    Posted 4 days ago
      |   view attached

    Dear Vilmar

    Thanks for your support and it was fine to me my requirement is addressed.

    i have a problem in same calculation.

    I want to see by location wise then the calculation is showing incorrect; I don't know where i'm wrong. Could you help this please

    i have uploaded the same file 

    -

    ------------------------------
    Kumar Kumar
    ------------------------------

    Attachment(s)

    pbix
    InventWorkings.pbix   4.22 MB 1 version