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.
Excel Formula for above one : =INDEX($AM$9:$AM$20,MATCH(D15,$E$9:$E$20,0))
Now i need to implement the same in DAX Calculated Measure.
First i need to get month from "ReportingMoth" cloumn then i need to search same moth in "FiscalMonth" column after taht need to get respected moth value from "monthsCover " column and finally need to display the same in value new column "MothsCoverMatch".
Here MothCover := Actual/Total is Calcualted Meaure.
Now i need to do same in Dax as Calcualted Measure/Column, Please provide the suggestinos to achieve this one.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |