Forum Discussion

Prabhu_MDU's avatar
Prabhu_MDU
Icon for Advocate I rankAdvocate I
7 years ago

Alternate for my SQL query in DAX

,cte_Allocation as ( select distinct cr.RemittanceCode, sum(fa.AllocAmount_OC_A) as 'AllocationAmount_Orig', sum(fa.AllocAmount_FC_A) as 'AllocationAmount_Func' from cte_Remittance cr /* <= A ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Prabhu_MDU can you share how you joined the table  in powerBI? Do you have calendar table in your model? I guess you @AsofDate is a parameted and you want to run query on or before that? Assuming you will use this as a slicer in PowerBI.

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

parry2k - just wanted to confirm if it still stays true that we cannot run queries with a parameter defined in SQL like a stored procedure like exec stored_proce @Date and then allowing users with a date slicer which feeds in that defined parameter, but this can be achieved in Paginated Reports?