Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Date range selection operator in Dax

    Posted Aug 09, 2022 05:28 PM
    Dax formula for range lookup returns the following error:


    Tried converting the data type to Date but it is still rendering it as a number. Is there a different operator that will work similar to ".."?


    ------------------------------
    Sana G.
    Sabre Limited
    Cambridge ON
    519-585-7524
    ------------------------------


  • 2.  RE: Date range selection operator in Dax

    Posted Aug 09, 2022 09:39 PM
    Tente

    ={Number.From([FirstCurrencyExchangeDate])..Number.From([EndOfMonthToday])}​


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



  • 3.  RE: Date range selection operator in Dax

    Posted Aug 10, 2022 10:36 AM
    The ".." operator doesn't work on Number, Date, DateTime, Text. I tried different data types to test and all returned the same error.

    To select a range, is there an operator other than ..?

    ------------------------------
    Sana G.
    Sabre Limited
    Cambridge ON
    519-585-7524
    ------------------------------



  • 4.  RE: Date range selection operator in Dax

    Posted Aug 10, 2022 12:03 PM
    Outra opção:
    =List.Dates([FirstCurrencyExchangeDate],Duration.Days([EndOfMonthToday] - [DataPedido]),#duration(1, 0, 0, 0)))


    Mas que estranho não ter dado certo para você.

    Este é o que eu fiz por aqui:


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



  • 5.  RE: Date range selection operator in Dax

    Posted Aug 10, 2022 01:24 PM
    The fields are not actual dataset fields which is why I cannot use the square brackets and perhaps that's why it doesn't work for me. I am working with a report someone else created.








    ------------------------------
    Sana G.
    Sabre Limited
    Cambridge ON
    519-585-7524
    ------------------------------