Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all!!
I am new to Power BI and DAX functions and I would be really thankful if you could help me with this!!
I am trying to recreate the following sql script with a dax function:
select id_region, min(date)
where n_products <> 0
group by id_region;
So lets say I have a product that I have just launch in the market in several regions and I am evaluating my marketing campaing. I have a record of the number of products that I sell each day in each region (each record will have a zero for the "number of products sold" until I dont start selling products)
Basically I have a table with three columns (id_region, date and num_prod --number of products sold--) so for each region I have a record of the number of products that were sold each day (for a particular product).
--> I want to create a measure that gives me the first day that this product started being sold in each region (I dont need the region in my DAX since I will aggregate it later in Power BI)
I have created the followint DAX function but its giving me a wrong result:
prod_date1 = CALCULATE(min('productA'[date] ),
FILTER ( 'productA',
'productA'[num_prod] <> 0)
)
Thank you sooo much in advance!!!!!!!!
Isabel
Solved! Go to Solution.
Hi @isasai87 ,
You can drag the region_id to the table visual and this measure:
Measure = CALCULATE(MIN('Table (2)'[date]))
However, it's better if you post some data and expected results as example. Just to check what you have so far.
Check it:
Hi @isasai87 ,
You can drag the region_id to the table visual and this measure:
Measure = CALCULATE(MIN('Table (2)'[date]))
However, it's better if you post some data and expected results as example. Just to check what you have so far.
Thanks @camargos88 , you are right, I shoudl have posted some data.
Here it is a sample of the data set and what I am expected to get:
I have more regions that this and I would like to create a measure that gets me the day when I started geting sales in each region. In PowerBI then I would use the measure that involves DATE and N_PROD and then present it in a table aggregated by region.
In SQL this is somthing quit simple but I just dont get the right DAX formula to implemented in Power BI 😞 😞 😞
Thank you very much again! 🙂
Isabel
Check it:
Thank you very much!!!
I cant believe it was so easy!!
I was actually close but I was complitely obsessed with using "filter" 😅
Thanks 😊
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
9 |