User Profile
Jyaulhaq
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Promote Headers via dax or not use function Promote headers
Hi, I have Sales Table country wise : how can I create new table with First row as header using 1. DAX 2. not using function Promote Headers(at Power query) Output: Note: I would like to get via: 1. DAX 2. not using function Promote headers(at power query) ThanksTop 1 value and best month from Measure
Dear Friend, I have two tables, Calendar(Date,Month) and Sales(Date,Sales) Tables. I calculated Measure1 using dax with help of Dates column and Sales Column from Sales Table.The output of Measure1 as shown below by Calendar(Month). Calendar(Month) Measure1 Jan-24 20 Feb-24 10 Mar-24 30 Apr-24 15 I have Month Slicer on report. Requirement: when I select any month slicer i want to get top 1 value where Month<=Max(month) from Measure1. For example: i select Feb-24 , output will be Measure2=20 and MonthTop=Jan-2024, or when i select Apr-2024 the output will be Measure2=30 and MonthTop=Mar-2024. How can i achieve this using DAX.Top value
Dear Friend, i have two measures: Hours and Day as output data shown below, i want to get Top 1 Hours and Day based on Hours. result for below data: Top1: 56,758 hours and 23 Day Another example: if i will have data like below, if Day is empty then then Hours=Hours+last above hours and Day=Day+above Day. here Day is empty in April so Hours=41000+23371=64371 and Day=23+30, the result table in on right side. then we need to find Top1 based on hours i.e. hours=64371 and Day=53 Another example: then Top1 is Hours=13419 and Day 58 how can i get using Dax ?
