Power BI Exchange

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

create a new table using filter from a measure - so the new table will show only respective rows for columns in range and show in the matrix columns only months in ranges dynamically

  • 1.  create a new table using filter from a measure - so the new table will show only respective rows for columns in range and show in the matrix columns only months in ranges dynamically

    Posted Dec 28, 2022 02:48 PM

    I tried parameter field, calculated table and many other options, I can do it w/out the slices but point of the powerbi is to use slices and see visuals changes, I can't believe that I can't create a table in memory with such to use in powerbi, I hope that I'm doing something wrong, I know C# and VB and others, but DAX is new to me.

    data.xlsx

    data.pbix



    ------------------------------
    Andre Moraes
    ------------------------------