Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |