Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
120 | |
74 | |
72 | |
63 |