Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
freginier
Solution Specialist
Solution Specialist

Repeat value of min date

 

Hi 

 

I have a table like this 

 

DateTicketKPITypeValue
01/01/2020TICK01KPI01Recurring10
01/02/2020TICK01KPI01Recurring

8

01/02/2020TICK01KPI02No Recurring7
01/03/2020TICK01KPI02No Recurring6
01/03/2020TICK02KPI03Recurring12
01/04/2020TICK02KPI03Recurring13

 

I have a slicer to select month and year and I select multiple month.

I would like to have a measure that repeat the sum of the min month on each row. For example if I select February & 2020 I should have 15 on all rows (selected).

 

How can I do this ? 

 

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
ryan_mayu
Super User
Super User

@freginier 

you can try this

Measure 2 = 
var _mindate=min('Table 2'[Date])
var _minmonth=month(_mindate)
var _minyear=year(_mindate)
return sumx(FILTER(ALL('Table'),year('Table'[Date])=_minyear&&month('Table'[Date])=_minmonth),[measure])

don't create relationship between fact table and date table.

1.PNG

pls see the attachment below





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ManguilibeKAO
Resolver I
Resolver I

Hi freginier,

 

Could you show the output you want?

 

Best regards.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.