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'm new to PBI.
I need to remove data from my query if that data has a leaving date of last day of the month? what measure would be best for this?
I have been removing these manually from my report then uploading it to my BI desktop but i no longer want to do this?
thanks in advance
Solved! Go to Solution.
Hi @ShelRose ,
power BI has a EOMPNTH function to obtain the last day of the month.
That might be helpfull for your case. Please check this article for more information on it.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |