Default assumptions to a Natural Language Q&A PowerBI Linguistic

[sjehanzeb]

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

[Icey · Accepted solution]

Hi @sjehanzeb ,

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

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.

[sjehanzeb · Accepted solution]

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 · Accepted solution]

Hi @sjehanzeb ,

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

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.