Forum Discussion
Help with report visual
Hi Ibendlin, thank you for the reply. I figured out my solution by using the Unpivot Columns feature in Data Query.
In summary, I duplicated my original data query, removed unecessary columns, selected the date columns and unpivoted them so that I had a new table with three columns: the [App ID] column, an attribute column representing the date name, and a value column representing the date value. I was then able to create a relationship between the original data query and the duplicate query using the Relationship Manager in the Model section of Power BI desktop.
Following that, I created several measures to count MTD, LMTD, YTD, and ITD based on the duplicate table's data.
If someone else stumbles upon this post and is facing a similar challenge, feel free to reply or message me and I'd be happy to go into more detail.
Hi Ibendlin, thank you for the reply. I figured out my solution by using the Unpivot Columns feature in Data Query.
In summary, I duplicated my original data query, removed unecessary columns, selected the date columns and unpivoted them so that I had a new table with three columns: the [App ID] column, an attribute column representing the date name, and a value column representing the date value. I was then able to create a relationship between the original data query and the duplicate query using the Relationship Manager in the Model section of Power BI desktop.
Following that, I created several measures to count MTD, LMTD, YTD, and ITD based on the duplicate table's data.
If someone else stumbles upon this post and is facing a similar challenge, feel free to reply or message me and I'd be happy to go into more detail.