cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ivric Frequent Visitor
Frequent Visitor

Creating a measure in dimension power bi desktop

I'm trying to do some calcualtion by creating a new Measure in a dimension named Programs on power bi desktop

if 'Programs'[StartDate] is blank then pick 'Programs'[AltDate] else pick 'Programs'[StartDate] 

 

but in the measure i created under Programs I could access the date columns in my DAX.

 

I'm connecting power bi live to ssas tabular cube.

 

 

Thanks,

1 REPLY 1
v-xjiin-msft Super Contributor
Super Contributor

Re: Creating a measure in dimension power bi desktop

@Ivric

 

@Ivric

 

I have made some tests by using live connection SSAS tabular as data source. However I cannot access date columns in DAX under my dimension. I can only access the measures.

 

As you can see in this article: Using Analysis Services Tabular data in Power BI Desktop. When connecting live, no data from the Tabular model is imported into Power BI Desktop. Each time you interact with a visualization, Power BI Desktop queries the Tabular model and calculates the results you see.

 

So How did you access the date columns in DAX? What kind of measure did you create? Could you please share us more information like some screenshots of your report or the measure which contains the date columns if possible?

 

Thanks,
Xi Jin.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 239 members 3,398 guests
Please welcome our newest community members: