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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sjehanzeb
Resolver I
Resolver I

Default assumptions to a Natural Language Q&A PowerBI Linguistic

I have some accounting data with entire, category and calendar table

I want my powerboat linguistic to answer queries assuming some default values e.g. 

 

what is my sales [assume current year sales] 

 

I have been able to connect sales with category and amount though it is still showing total value not the current year. 

 

for working around the solution, i made a measure named "Current" is now() at its formula 

 

but how can I make the system assume current in my example above

 

 

 

Date
GL  Code
Amount

 

GL Code
Category

 

Date
Month
Year
2 ACCEPTED SOLUTIONS
Icey
Community Support
Community Support

Hi @sjehanzeb ,

 

I create a sample. Please check if this is what you want:

 

qa.PNG

 

Or you can use "this year". Both have the same effect.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

sjehanzeb
Resolver I
Resolver I

this wasn't exactly what i was looking for. the problem is that I related the information to fiscal year and not calendar year. 

 

but as the question did not mention this, i am accepting the answer as correct. 

 

View solution in original post

2 REPLIES 2
sjehanzeb
Resolver I
Resolver I

this wasn't exactly what i was looking for. the problem is that I related the information to fiscal year and not calendar year. 

 

but as the question did not mention this, i am accepting the answer as correct. 

 

Icey
Community Support
Community Support

Hi @sjehanzeb ,

 

I create a sample. Please check if this is what you want:

 

qa.PNG

 

Or you can use "this year". Both have the same effect.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.