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.
Hello,
I would like for my Pivot table to use a user selection as a cut-off point for the data presented.
For instance, if I have a client who owes money from September, upon selection of October, I would like to view the balance due from both September AND October. However, anything beyond October would be ignored.
I believe my issue lies in the relationship between my Fact and Date Dimension (Many-to-one respectively). The way I perceive this working is the relationship is only taken into account prior to the selected value, otherwise ignore it. The reality of the situation is that the selection is being considered so no prior months are included.
I've tried the ALL, ALLEXCEPT, and CROSSFILTER Functions to no avail.
Here is my code:
CALCULATE(sum('Deliver TRANSACTION_FACT_UNION'[Amount]),
'Deliver TRANSACTION_FACT_UNION'[TxnType] = "Invoice",
FILTER('Deliver TRANSACTION_FACT_UNION','Deliver TRANSACTION_FACT_UNION'[TxnDate] <= [Open Invoice Date Slicer]),
'Deliver INVOICE'[IsPaid] = false(),
'Deliver INVOICE'[IsPending] = false(),
'Deliver TRANSACTION_FACT_UNION'[TransactionSummaryFlag] = TRUE())
Any suggestions?
Thanks!
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.