Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have the following dataset:
And I have the following Matrix
Where the second column "Somma di Cost" is made with a simple DAX formula SUM(Budget, Budget[Cost]).
I also have a slicer with Date-Number.
I want to create a measure that calculates "Somma di cost"/MAX(Date, Date[Number])*Number selected with slicer.
Is that possible?
Thank you
Solved! Go to Solution.
@Filippomonti , for Number selected with slicer use what if parameter https://docs.microsoft.com/en-us/power-bi/desktop-what-if
@Filippomonti , for Number selected with slicer use what if parameter https://docs.microsoft.com/en-us/power-bi/desktop-what-if
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |