Forum Discussion
Create Date Function. Help.
Good Morning!
I got what I needed. I changed the table to be applied to the function and it worked.
Thank you very much for your support.
Att.
Robson
No problems. I apologize, I don't speak English, I use Google Translate.
Photos attached.
Summary:
I have a Table of the General Register of Employees:
Competence is the date of the file that every month will have one of April, May June......
In the same table I have the Admission column and the Dismissal column
Objective:
Make the BI in the data segmentation filter the month by competence. Example: April and another filter the Year 2022
When you click on the month and year of April 2022, the function needs to show a card called Total Dismissed in April 2022 and ignore those dismissed on 05/2022, because the Competency file is from 30/04/2022.
In the Dismissal column I have the dates of 12/04/2022 and I have the dates of 11/05/2022 and 04/05/2022
I need the dax function to do a count of how many dates from 04/2022 are in the Dismissal column, ignoring the dates from 05/2022.
Att.
Robson
AndradeRobson
Thank you for the briefe description. Actually I have many fiends from Brazil and I think it is time to learn some Portuguese. I believe it is too late now in Brazil and probably you'll get to be soon.
I don't see any reason for not having the correct result out of this code. Maybe we can connect via zoom or teams. Don't worry my english is no much better than yours 🙂