monthly

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!
Solved
Anonymous
2 years ago Place DAX Commands and Tips
1.3KViews
0likes
2Comments
Displaying Data for every N Months (Every 3 Months , Every 12 Months)
The Use Case : The Slicer has 4 options to select data from : 1. Daily - Select Start and End Date in the slicer - Display the data based on the date Selection 2. Monthly - Select Start and End Date in the slicer - Display the data for All Month End Dates between the Range 3. 3 Months - Select Start and End Date in the slicer - Display the data for All Month End Dates between the Range BUT now the difference between the month end dates should be 3 Months and not 1 month. 4. 12 Months - Select Start and End Date in the slicer - Display the data for All Month End Dates between the Range BUT now the difference between the month end dates Should be 12 Months. For futher reference please find the attached screenshots of different output scenarios
Udit_C
4 years ago Place Custom Visuals Development Discussion
1.1KViews
0likes
0Comments