If there is a requirement of creating an Age slicer which is numeric slicer and only date of birth is available in data model then we can achieve by getting fractional year value between date of Birth & Current date using YEARFRAC DAX function.
YEARFRAC function: Calculates the fraction of the year represented by the number of whole days between two dates.
YEARFRAC(<start_date>, <end_date>, <basis>)
Note: <basis> is optional
Create a new column named "Age" with below formula
Table
Name – Employee
Column
Name – DateofBirth
Age = INT(YEARFRAC(Employee[DateofBirth]),TODAY(),1))
Create a new slicer for "Age" with newly created column "Age".
Board officials have given the AP Intermediate exam Model Question Paper 2023 . Main Exams will start from 28 February for AP Inter 1st year examination & for Andhra Pradesh intermediate public examinations ii year will start from. AP Board Sr Inter Previous Papers 2023 2023 according to BIEAP latest intermediate exam New Question Paper 2023 .
ReplyDelete