Power BI Exchange

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

View My Drafts

  • 1.  VIRTUAL TABLE

    Posted May 11, 2022 08:10 AM
    Edited by Kumar Kumar May 11, 2022 08:13 AM
      |   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 May 14, 2022 02:48 PM
      |   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
    Original Message


  • 3.  RE: VIRTUAL TABLE

    Posted May 17, 2022 04:01 AM

    Thank you Vilmar Santos

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



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

    Original Message


  • 4.  RE: VIRTUAL TABLE

    Posted May 19, 2022 07:48 AM
      |   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
    Original Message


  • 5.  RE: VIRTUAL TABLE

    Posted May 25, 2022 04:18 AM
    please support me,

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

    Original Message