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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
freginier
Impactful Individual
Impactful Individual

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.