Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
I have a logic like below,
⦁ Pull all the invoices for Agency Bill policies that are hitting the GL (based on later of effective or entry date) during the report run period, e.g.
⦁ If an invoice is created in January 2021 but with an effective date of March 2021, then it should appear in the report for the month of March 2021.
⦁ If an invoice is created in February but with an effective date backdated to January 2021, then it should appear in the report for the month of February.
please help me how to create a dax function on the above logic.
Thanks in advance.
@Anonymous , You need measure like
calculate(count(Table[Invoice]), filter(Table, Table[Type] = "Agency Bill" && eomonth([effective date], 0) = eomonth([report run period], 0)))
calculate(count(Table[Invoice]), filter(Table, eomonth(Table[invoice Date],2) = eomonth(Table[effective Date],0)))
calculate(count(Table[Invoice]), filter(Table, eomonth(Table[invoice Date],-1) = eomonth(Table[effective Date],0)))
The second and third is made generic using month gap
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
83 | |
82 | |
72 | |
49 |
User | Count |
---|---|
143 | |
130 | |
108 | |
64 | |
55 |