How to compare current selected month and the month before's data
Hi all, I have a dataset which records the value of three KPIs each month. I currently have a multirow card which displays these KPIs, connected to a slicer so that I can see each month's totals. For example, for January 2023: I would like to display next to this card the difference between the selected month's values and month prior to it. For example, if January 2023 were selected, I'd like it to show +5 for number of activity cards (because 0 were produced in Dec 2022), +2 articles and +3 Lunch and Learns. How is the best way to do this? I am a complete Power BI novice, so I'm not sure where to start! Thanks, HShow result in a card by a measure only if a row is selected on a matrix
Hi everyone! So, I got an dashboard that shows when a certain phase of the project is seted to finish on a matrix, futhermore, I display the latest seted date (on the yellow triangle) and the previous forecast date (on red diamonds): I've writed a measure that calculates deviation between this two dates: Desv_02/23 = FORMAT( (SUMx( d_EAP, d_EAP[BL1] - d_EAP[BL2])), "###0") The problem is that I wanted to display the result on this card only when a Row is selected at the matrix above, because this measure how it is today returns the whole calculation for every row on the matix. I hope that you could understand this problem and that you could help me wiht this one!
