Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi All,
Have another query that wish to get your inputs please
I have 2 tables
1 table is a list of new products ex.
TBL_NewProduct
And have another TBL for the Invoice data
Here's the output that I would want to achieve as an additional column, so basically if the invoicedate is within the DateLaunched and MaxNewProductListed dates then it will be included in the sum of the output
Thanks!
Solved! Go to Solution.
@mangchaaBI
Same as my orgianl reply
New Column =
VAR __LaunchDate = TBL_NewProduct[DateLaunched]
VAR __ListedDate = TBL_NewProduct[MaxNewProductListed]
VAR __Product = TBL_NewProduct[ItemName]
RETURN
CALCULATE(
SUM(TBL[Total]),
TBL[InvoiceDate] >= __LaunchDate,
TBL[InvoiceDate] <= __ListedDate,
TBL[ItemName] <= __Product
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @mangchaaBI ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
@mangchaaBI
Use this meaure:
VAR __LaunchDate = TBL_NewProduct[DateLaunched]
VAR __ListedDate = TBL_NewProduct[MaxNewProductListed]
VAR __Product = TBL_NewProduct[ItemName]
RETURN
CALCULATE(
SUM(TBL[Total]),
TBL[InvoiceDate] >= __LaunchDate,
TBL[InvoiceDate] <= __ListedDate,
TBL[ItemName] <= __Product
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
hi @Fowmy Thanks for taking the time to answer, just ran into a bump where I can't seem to add the variables into the equation, thanks
@mangchaaBI
Sorry, Please add this code as a calcualted column to your TBL_NewProduct table.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@mangchaaBI
Same as my orgianl reply
New Column =
VAR __LaunchDate = TBL_NewProduct[DateLaunched]
VAR __ListedDate = TBL_NewProduct[MaxNewProductListed]
VAR __Product = TBL_NewProduct[ItemName]
RETURN
CALCULATE(
SUM(TBL[Total]),
TBL[InvoiceDate] >= __LaunchDate,
TBL[InvoiceDate] <= __ListedDate,
TBL[ItemName] <= __Product
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you I think this is what I need, problem is that I'm getting a low resource error on my pBI desktop app 😅 cant confirm if this is the fix for me, but I'll tag it as the solution for anyone who wants to try
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
76 | |
74 | |
56 | |
45 |
User | Count |
---|---|
117 | |
105 | |
77 | |
66 | |
64 |