Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Hope you understand my problem, it is for work. Thanks in advance.
Hi,
Explain the business context, share some data and show the expected result.
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.
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.
If you take datediff you can create bucket. The bucket can be based either diff between today and check a date or Recepirt date?
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.
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
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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |