subscription
2 Topics
Visualizing monthly payments until contract ends
Hi, i have the following situation: I'd like to create a bar graph, which shows me the montly payments i receive from different accounts, until their contracts end. In my table i have the information of the montly fee, the entire amount left to pay and the end date. If i'd create a table with the expiring date on the x axis and the monthly fee on the y-axis, obviously the graph will only show me, which monthly fee expires when. But i'd like the monthly fee to show up in graph every month, until the contract is expires. Hope it's explained well enough. Can anyone help me out with this? Thanks in advance!Solved1.3KViews0likes2CommentsReplace/Substitute text in specific column using DAX
I need to replace a text in a specific column, but as my report comes from a cube, I cannot manipulate the data using Power Query or Add Columns, the only option I have is to create a measure using DAX. I did a research and I could use Replace or Substitute, but I'm still not quite sure how to replace a text every time it appears in the column. Below is an example in excel of what I'm looking for to do in PBI. In this example, I need to substitute/replace Apple for Pear. Original Names NEW Names Apple Pear Banana Banana Strawberry Strawberry Apple Pear Banana Banana Strawberry Strawberry Strawberry Strawberry Strawberry Strawberry Banana Banana Banana Banana Apple Pear Banana Banana Apple Pear Apple Pear Strawberry Strawberry Apple Pear Banana Banana Strawberry Strawberry Strawberry Strawberry Strawberry Strawberry Banana Banana Banana Banana I appreciate any help. Thanks!Solved11KViews0likes4Comments