Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  wrong matrix column total

    Posted Dec 01, 2022 02:44 AM
    Hello BI expert,

    Could you please help me with this issue in using matrix.  The total showing 31 and it should be 365 days for year 2019 and 366 days for 2020



    ------------------------------
    Ronie Soriano
    ------------------------------


  • 2.  RE: wrong matrix column total

    Posted Dec 01, 2022 08:37 AM
    solved already using datediff()

    ------------------------------
    Ronie Soriano
    ------------------------------



  • 3.  RE: wrong matrix column total

    Posted Dec 06, 2022 10:32 PM
    Olá

    Days per Month =
    COUNT ( dCalendar[Date] )​



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



  • 4.  RE: wrong matrix column total

    Posted Dec 08, 2022 06:56 AM
    muchas gracias

    ------------------------------
    Ronie Soriano
    ------------------------------