Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
I am trying to create a monthly profit and loss report that displays both actual and budget relative to the date selected.
I can use the matrix visual and add measures for actual P&l and budget. That's ok, however I would like to show only the actual relative to the month selected, and the remainder being budget.
I have tried a logical agrgument, but just can't seme to get this right. Either it starts summing all of the actual months together, creates and error.
the ideal scenario would like something like...
Actual Actual Budget Budget Budget..... etc for a financial year
Jul-19 Aug-19 Sep-19 Oct-19 Nov-19
Below is the DAX I have tried using but I can't seem to filter the first few months to only show the actual relative to the month selected in a slicer.
Help when you know. Ask when you don't!
thank you for the suggestion... though it's not giving the desired output
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |