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.
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.
@RadhaE , 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
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.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |