Filter a measure by a date, that is already filtered by another date

[gazz9ar]

Hi guys, in the last post maybe i confused too much so i deleted it.

Im having trouble getting the SUM of "Check Total" from a list of Receipts (Incoming Payments) based on the "Check Date"

I have this measure:

Total Receipts = SUMX(DISTINCT(Receipts[TransId]);[MAX Total Payment])

*[MAX Total Payment] = MAX(Total Payment)

----------------------- i get correctly the total of receipts

Checks Total = CALCULATE(

SUMX(DISTINCT(Receipts[TransId]);[MAX Total Check]))

--------now i get the checks total from the receipts

NOTE that Checks Total is using this RELATIONSHIP  [Date]Date = Receipts[Receipt Date]

Now what i need is to show  from that Checks Total, BASED on "Check Date" show the Checks Total within a range of days.

Image: Blue Dot Total Cheques = Checks Total ;  DIAS = DAYS ; Sorry its in Spanish, hope you understand.

 Hope you understand my problem, it is for work. Thanks in advance.

[Ashish_Mathur]

Hi,

Explain the business context, share some data and show the expected result.

[gazz9ar]

I will try to show you, hope you understand.

First, the user selects a period: december 2019 for example. Lets analyze the 2 measures in 13th December:

Nice, once i know what is the Check Total for a specific period, i will breakdown this table.

Okay, as you can see there is a LOT of Checks for every day of December.

So, standing in the date of TODAY and using the Check Date, what is the Checks Total for TODAY?, what is the Checks Total for 1-15 DAYS,15-30 DAYS, ETC.

So we go again with this visual.

Sorry its in Spanish, hope you understand.

Example Conclusion: From all the Receipts i made in December of 2019, How many money$ in Checks i have for TODAY, 1-15 DAYS. ETC.

Of course if you want to know how many money$ in Checks you have, you need to use the Check Date.

Thanks guys.

Regards.

[amitchandak]

If you take datediff you can create bucket. The bucket can be based either diff between today and check a date or Recepirt date?

[gazz9ar]

What a basically need, would be a dynamic table based on the Slicer of the Period.

Once i have this table containing all receipts from that Period, i just have to sum the checks amount based on Check Date.

[amitchandak]

In case you are trying to create a new formula using the check date. Please refer to the article below. In case of the same formula filter of check date. then add a filter of check date in formula and use the dates from the calendar

Check how two dates are used to calculate formula using the same calendar

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Check how two Date tables are used

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...