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

Back to discussions
Expand all | Collapse all

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
    ------------------------------